View original (French)

Formula if a cell does not contain two words

amelise Posted messages 53 Status Member -  
DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   -
Hello,

I'm looking to know how to write a formula that says:

If A4 does not contain "boat" and "truck" and if AE4 does not contain "boat" and "truck"; then write in the cell where I entered the formula "plane".

I hope that's clear.

Thank you for your help!

1 answer

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Hello,

    =IF(AND(SEARCH("boat", A4), SEARCH("boat", AE4), SEARCH("truck", A4), SEARCH("truck", AE4)), "plane", "")

    Regards
    0