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
-
=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
-
=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","")))
-
Thank you so much!! This is perfect!