Can I insert Cell ref into text output

J

Jamie

Hi There

I think this is possible. I am using an If Statement to
output text to a cell. i.e "Jamie is leading by __
points."

Is it possible to insert a Cell reference, where I have
put __ into the text output?

Any help greatly appreciated

Cheers in advance

Jamie
 
O

Ole Michelsen

="Jamie is leading by " & D1 & " points."
or the function concatanate.

Ole
 
Top