I've tried multiple IF statement that I found on the web and can't seem to get any to work. I am looking to report back a TRUE or FALSE value based on a "certain word" in a cell. This word will not always be separated by spaces. For example: "CW2_MITC_FLR 7_APPROVESWAP" - I would like to report back a TRUE value if this field has the word "APPROVE" in it. It can't be case sensitive either.
Formula I have tried using =IF(ISERROR(FIND("Approve",G403)),FALSE,TRUE)
Any help appreciated!
Jen
find is case sensitive
and you need to use wildcards
so search is not case sensitive
try
=IF(ISERROR(SEARCH("*Approve*",G403)),FALSE,TRUE)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try this
Please Login or Register to view this content.
Shelton A.
If Helpful, Add Reputaion!
Here's another one...
=COUNTIF(G403,"*Approve*")>0
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
No need for either the IF function or the wildcards.Originally Posted by etaf
=ISNUMBER(SEARCH("Approve",G403))
Thanks Tony Valko for letting me knowalways useful to know.
Re: IF Stmt Returning a TRUE FALSE Value
Perfect! this works - thank you so much!!
Thank you Tony! Much appreciated!
You're welcome!Thanks Tony Valko for letting me know always useful to know.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks