If, or, isnumber, search
In cell F1, I need to find substrings A100, B100, OR C100 in cell D1, and if true, "Y", else "N". I can get it to find one of the 3 substrings using: =IF(ISNUMBER(SEARCH("A100",D1)),"Y","N")
and get the correct return, BUT, I haven't been able to figure out how to add the "OR" and the other substrings to the formula. Can someone help? Thanks.
Last edited by reb2u; 03-15-2012 at 10:51 AM.
Try:
=IF(OR(ISNUMBER(SEARCH({"A100","B100","C100"},D1))),"Y","N")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Use this
=IF(OR(ISNUMBER(SEARCH("A100",D1)),(ISNUMBER(SEARCH("B100",D1))),(ISNUMBER(SEARCH("C100",D1)))),"Y","N")
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- Mark your post SOLVED if it has been answered satisfactorily:
- Select Thread Tools (on top of your 1st post)
- Select Mark this thread as Solved
Hi
Another option:
=IF(COUNT(SEARCH({"A100","B100","C100"},D1)),"Y","N")
Thank you very much, NBVC, it worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks