View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Looking for the word "WIN" in a cell

If case is not important then you can use UPPER("win") and UPPER(A1)
=IF(ISERROR(FIND(UPPER("win"),UPPER(A1))),FALSE,T RUE)


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