Does not contain this or that TEXT

Corina.Goodwill

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

Sameer Karkhanis

=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","")))

Sameer Karkhanis

=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","")))

Corina.Goodwill

Thank you so much!! This is perfect!