Forum Discussion

Annalee2130's avatar
Annalee2130
Copper Contributor
Apr 08, 2019

IF Formula in Excel

I am trying to do an =IF formula with multiple logical options: =IF(OR(A5=CRM!A5,"CRM",[A5=Affiliates!A5,"Affiliate"],[A5=Supplier!A5,"Supplier]) But it is not accepting and I can't see where I'm goi...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 08, 2019

Annalee2130 , what is the logic for OR in plain English? Perhaps you need nested IF like

=IF(A5=CRM!A5,"CRM",IF(A5=Affiliates!A5,"Affiliate",IF(A5=Supplier!A5,"Supplier","nothing from it"))))

 

Resources