It doesn't seem to be working for a blank. For a blank I get a zero.

"Toppers" wrote:


=IF(ISTEXT(C1),1,0)

will return 1 if text or blank and 0 if a number

HTH

"cvgairport" wrote:

Is there a way to test with an IF statement if a cell has is empty or "is
not" a number?

Thanks!

Amy