Excel 2007 : IF function returning wrong value

I have a cell I am referencing (J24) that usually would have a number value (ex. 5%, 5, 5.0) of some sort but has N/A in it right now because I do not know the number at this time. My function is this:

=IF(J24>=5%,1,0)

The function is returning 1 even though the value is not >=5%, it is N/A. It should be returning 0 since it is false. This is what I want it to do.

Please help!

bdinsdale,

Can add a check to make sure the cell contains a numeric value:
=IF(AND(ISNUMBER(J24),J24>=0.05),1,0)

Hope that helps,
~tigeravatar

Yes, that helps! Thank you!

Fyi, XL always considers a string larger than a number