That probably means that it's not blank, but has an empty string "", which
isn't the same.

David Biddulph

"cvgairport" wrote in message
...
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