Or you can use SEARCH, which is not case-sensitive, instead of FIND.

Hope this helps.

Pete

On Nov 13, 11:29*pm, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64)
& "hotmail.com" wrote:
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- Hide quoted text -

- Show quoted text -