Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Need help with if formula with multiple options

Topic Labels: Formulas
103 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I need quite help with a formula. Currently, my formula is as follows which says If FIELD A = “Hubspot Invoice”, then use Field B to populate cell, otherwise use field C.

currently, my formula is IF({FIELD A)}=“HubSpot Invoice”, {FIELD B}, {FIELD C)})

however, I’d like it to say if “FIELD A = HUBSPOT INVOICE” OR FIELD A = “ZOHO INVOICE”, Field B to populate cell, otherwise use field C.

How do i capture the two conditions in the If field?

1 Reply 1

Hi @Sahil_Mehta,
This should do it for you

IF(OR(A='HUBSPOT INVOICE',A='ZOHO INVOICE'),B,C)

Be careful of the text case, in one example you have Upper case and in another you have Lower case. If the options are a drop down, enter them exactly as they are in the drop down.