Looking for the word "WIN" in a cell
Your formula seems NOT to fail with Lose, Lose, Winfield
--
Francis L. Kulchar
"T. Valko" wrote in message
...
If case is not important then you can use UPPER("win") and UPPER(A1)
=IF(ISERROR(FIND(UPPER("win"),UPPER(A1))),FALSE, TRUE)
If case is not a factor just use SEARCH and "win":
=IF(COUNT(SEARCH("win",A1)),TRUE)
However, that will fail in these cases:
Lose, Lose, Winfield
Lose, Lose, Winfield
--
Biff
Microsoft Excel MVP
"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote
in message ...
Try
=IF(ISERROR(FIND("win",A1)),FALSE,TRUE)
It will not match Win though...
If case is not important then you can use UPPER("win") and UPPER(A1)
=IF(ISERROR(FIND(UPPER("win"),UPPER(A1))),FALSE,TR UE)
"F. Lawrence Kulchar" wrote:
Now van I test for a true-false issue in a cell containing the word
'WIN'??
For example, the followinh cells would provide the following vresults;
win, P1 TRUE
P2, Pa3 FALSE
P4,KING, win TRUE
Tr,win,dr,win,lose TRUE
Lose, Lose, Winfield FASLSE
Lose, Lose, Winfield FALSE
Thanks, FLKulch
|