Looking for the word "WIN" in a cell
Your formula seems NOT to fail with Lose, Lose, Winfield
Which formula? This one:
=IF(COUNT(SEARCH("win",A1)),TRUE)
That formula returns TRUE which is incorrect according to the results you
wanted as posted in you sample.
This formula returns FALSE which is correct according to the results you
wanted as posted in you sample
=ISNUMBER(SEARCH(" win "," "
&SUBSTITUTE(A2,","," ")&" "))
--
Biff
Microsoft Excel MVP
"Francis L. Kulchar" wrote in message
...
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
|