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

Thanks!

Amy

=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

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

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

=if(a1="","It looks empty","It looks like it's not empty")

You can use:
=if(isnumber(a1), ...

to check if it's a number.

or
=if(istext(a1), ...
to check to see if it's text.





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

--

Dave Peterson