IF function not performing as expected

[L.LEE]

Hi, I have an IF statement that does not return the expected value.

I don't understand why a cell that contains the text "yes" would be seen by excel to be greater than a date.

thanks

[Crooza]

because it orders by alphanumeric. ie numbers first then text. Dates are numbers.

[L.LEE]

Sorry I don't understand the reply. If it goes by numbers first, and "yes" is not a number, why does it return TRUE?
How should I write the formula so that it will return FALSE?

[vlady]

try

Please Login or Register  to view this content.