• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Condition based formula (needs some modification)

arifanmol

Member
Plz check attached sheet and respond
in listed itmes, there must be NO against item no. 5 as it contains neither cable or tray
but it shows blank =IF(AND(ISNUMBER(SEARCH("cable",B3,1)),ISNUMBER(SEARCH("Tray",B3,1))),"No",IF(ISNUMBER(SEARCH("cable",B3,1)),"Meter","")) was applied
 

Attachments

  • mysheet.xlsx
    8.9 KB · Views: 2
Back
Top