Does not contain this or that TEXT

Options

Hello,

We currently have a formula that works to say if the variation row contains E-Gift, the cell will say E-Gift Card and if it contains Physical Card the cell will say Physical Gift Card.

=IF(CONTAINS("E-Gift", Variation@row), "E-Gift Card", IF(CONTAINS("Physical Card", Variation@row), "Physical Gift Card"))

This works. However, we want to add that if the cell in variation row does NOT contain the word card, it will say company product.

I Tried adding IF(NOT(CONTAINS("Card", Variation@row)), "Company Product") to the above formula and got #UNPARSEABLE

Any help is appreciated

Tags:

Best Answer

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Answer ✓
    Options
    =IF(CONTAINS("E-Gift", Variation@row), "E-Gift Card", IF(CONTAINS("Physical Card", Variation@row), "Physical Gift Card", IF(NOT(CONTAINS("Card", Variation@row)), "Company Product","")))
    
    

Answers