Leave Cells Blank

[Guest]

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

 

[Guest]

=if(i27<45,"",if(i27>=45,"F","S"))

 

[KL]

=IF(I27="","",IF(I27>=45,"F","S"))

Regards,
KL

 

[Harlan Grove]

Duke Carey wrote...

=if(i27<45,"",if(i27>=45,"F","S"))

....

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.