Leave Cells Blank
 

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

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

"Mary" wrote:

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

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

Regards,
KL


"Mary" wrote in message
...
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

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.