FIND formula help needed
=IF(ISNUMBER(FIND("Overall",B2)),"Y","N")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Carole O" wrote in message
...
Excel 2000
The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE! always
appears.
Any ideas?
CaroleO
|