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
Bookmarks