IF statement question

[Guest]

I feel very foolish asking this, but must ask all the same.

When I include this IF statement:
=IF(A1="","",IF(A1=0,"Zero",IF(A1>1000,"Rich","")))

all works out well, unless you put anything other than a NUMBER in A1. If a
letter is in A1, "Rich" appears in B1, where the IF statement is.

I have never seen this before, does anyone have any ideas of why? Am I being
particularly stupid?

Any help very much appreciated,
Beth

 

[Chip Pearson]

Beth,

Text values are always greater than numeric entries, so you need
and additional test for text entries. For example,

=IF(A1="","",IF(A1=0,"Zero",IF(ISNUMBER(A1),IF(A1>1000,"Rich",""),"text
entry")))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




message
news:[email protected]...

 

[Guest]

Chip,
I suspected that was what was happening, but wasn't sure how to correct it.
Thank you very much!

beth