=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
|