Leave Cells Blank

M

Mary

I would like nothing to display when there is no data in the linked cell.
Here is my formula:=IF(I27>=45,"F","S") S is always showing. If no data is
entered in the cell I27, how do I keep this cell's formula blank. Thanks in
advance, Mary
 
H

Harlan Grove

Duke Carey wrote...
=if(i27<45,"",if(i27>=45,"F","S"))
Click to expand...
....

When could this ever return "S"? The first IF catches *ALL* instances
that satisfy I27<45, so if that condition is false, the next IF call's
1st argument would necessarily be true.
 
Top