Formula Help
 

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

Thanks!

Amy

Formula Help
 

=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

Formula Help
 

=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

Formula Help
 

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

Formula Help
 

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