#value

[kwrigh6]

I have the following if statement: =IF((E10-D10)>=0,(E10-D10),"")
This formula means that if the subtraction of the 2 numbers is negative than it will be a blank cell. However, the cell E10 shows: "#VALUE!" because one of the cells it refers to in its formula doesn't have a number yet.
I want my IF statement to show a blank cell if E10 = "#VALUE!".
I hope this makes sense...

HELP!
Thanks

[Jonmo1]

Try

=IFERROR(IF((E10-D10)>=0,(E10-D10),""),"")

[6StringJazzer]

Try:

Please Login or Register  to view this content.

Drat! Beaten by mere seconds!

[JohnTopley]

Try ...

=IF(ISNUMBER(E10-D10),IF(E10-D10>0,E10-D10,""),"")

[kwrigh6]

=IFERROR(IF((..... worked! Thank you!