Skip to main content

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?

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.


Reply