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


Terms & Conditions