Thread
:
Formula Help
View Single Post
#
2
Posted to microsoft.public.excel.misc
Toppers
external usenet poster
Posts: 4,339
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
Reply With Quote
Toppers
View Public Profile
Find all posts by Toppers