IF THEN to test for numbers/words/empty spaces

[kolbydayne]

Does anyone know how or if If THEN statements can be used to tes
whether or not a cell contains either a number, a particular word, o
nothing at all (not a zero, but completely blank)?

Thanks for the help

 

[Peo Sjoblom]

=IF(ISNUMBER(A1),"Number",IF(COUNTIF(A1,"*Word*"),"Word
Found",IF(A1="","Blank","Neither")))

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Kyle]

for a particular number, just type in the number (ie. IF
(C8=40, 56, 57)). for a particular word, simply type the
word with quotes (ie IF(C8="go", 56, 57)). not sure about
the blank issue, so i won't speculate, sorry.

 

[Kyle]

for a particular number, just type in the number (ie. IF
(C8=40, 56, 57)). for a particular word, simply type the
word with quotes (ie IF(C8="go", 56, 57)). not sure about
the blank issue, so i won't speculate, sorry.

 

[hgrove]

Peo Sjoblom wrote...

=IF(ISNUMBER(A1),"Number",IF(COUNTIF(A1,"*Word*"),
"Word Found",IF(A1="","Blank","Neither")))

...

Quibble: possible OP needs ISBLANK(A1) rather than A1="" since if A
were text evaluating to "" it wouldn't be confused with 0