IF THEN to test for numbers/words/empty spaces

  • Thread starter Thread starter kolbydayne
  • Start date Start date
K

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
 
=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)
 
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.
 
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.
 
Peo Sjoblom wrote...
=IF(ISNUMBER(A1),"Number",IF(COUNTIF(A1,"*Word*"),
"Word Found",IF(A1="","Blank","Neither")))
Click to expand...
...

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