Does not contain this or that TEXT


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


Best Answer