Ignoring Blank Cells

[Reefaman]

Hi all
I am trying to put a result "R" in cell H13 if the value in cell D13 i
greater than or equal to zero. This is the formula I came up wit
=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 th
correct result when D13 is populated.
Thanks
Ree

 

[Bob Phillips]

=IF(AND(ISNUMBER(D13),D13>=0),"R")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[CLR]

Maybe.........

=IF(D13="","",IF(D13>=0,"R",D13))

Vaya con Dios,
Chuck, CABGx3