Ignoring Blank Cells

R

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
 
B

Bob Phillips

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

--

HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top