Return a single text value if either option A or option B from drop down list is selected

hpak

Hi there!

Looking for help with a formula that will be able to return a single text value "Not Applicable" in Column 2 if either Option A or Option B is selected from a drop down list in Column 1?

I think I'll need to use the IF and CONTAINS function but not sure how I might be able to join these two together?

Thanks in advance!

Kelly Moore

Hey @hpak

=IF(OR([Column 1]@row="Option A", [Column 1]@row="Option B"), "Not Applicable")

Does this work for you?

Kelly

Kelly Moore

Hey @hpak

=IF(OR([Column 1]@row="Option A", [Column 1]@row="Option B"), "Not Applicable")

Does this work for you?

Kelly

hpak

Yes- thanks so much for your help! That works great!