IF statement returning TRUE value when looking at text

[Oisin86]

Hello,

I am using an IF statement to look at a cell and determine if the cell is < than a defined number then return either "Yes" or "No" depending on the value in the cell. It is a very simple formula but the trouble I am having is that when the cell being examined contains a text value I want the IF statement to look at the cell, see that it is text and return "No". I've never had issues with this before but I think I may have changed a setting because now the IF statement looks at the cell sees that it contains text and returns a positive result.

Sorry if my explanation above is not clear but any help that people can provide with regard to getting my excel workbook back to its normal helpful self would be very useful.

Many thanks

Oisin

[samba_ravi]

=IF(COUNT(A1:B1)=2,IF(A1<B1,"Yes","No"),"No")
or
=IF(COUNT(A1),IF(A1<7,"Yes","No"),"No")

[pjwhitfield]

Please Login or Register  to view this content.