Thread: Formula Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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