Forum Discussion
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...
I am not sure what the square brackets were intended to be? An alternative to a nested IF that is available from Excel 2016 and on is the IFS function.
= IFS(
A5=CRM!A5, "CRM",
A5=Affiliates!A5, "Affiliate",
A5=Supplier!A5, "Supplier" )
PeterBartholomew1 , for IFS I'd add TRUE condition at the end if no one match