Need help with if formula with multiple options

[Sahil_Mehta]

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?

[Vivid-Squid]

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.