Hi all
I am trying to put a result "R" in cell H13 if the value in cell D13 is
greater than or equal to zero. This is the formula I came up with
=IF(D13=0,"R")
The trouble is when the cell is blank it still returns the result "R".
How can I leave H13 blank when D13 is blank but still return the
correct result when D13 is populated.
Thanks
Reef


--
Reefaman
------------------------------------------------------------------------
Reefaman's Profile: http://www.excelforum.com/member.php...o&userid=31968
View this thread: http://www.excelforum.com/showthread...hreadid=550802