Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |