I want a blank space on a worksheet when the question is blank?

P

Patrizia

I have an If statement the checks a value of one...when the cell is blank the
IF statement return a false...I would like the a blank space if there is no
info in the value cell.
 
D

Dave Peterson

=if(a1=1,"ok","")

(I think???)
I have an If statement the checks a value of one...when the cell is blank the
IF statement return a false...I would like the a blank space if there is no
info in the value cell.
Click to expand...
 
Top