C
cvgairport
Is there a way to test with an IF statement if a cell has is empty or "is
not" a number?
Thanks!
Amy
not" a number?
Thanks!
Amy
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
=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.
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.
T
Toppers
=IF(ISTEXT(C1),1,0)
will return 1 if text or blank and 0 if a number
HTH
will return 1 if text or blank and 0 if a number
HTH
C
cvgairport
It doesn't seem to be working for a blank. For a blank I get a zero.
D
David Biddulph
That probably means that it's not blank, but has an empty string "", which
isn't the same.
David Biddulph
isn't the same.
David Biddulph