Conditional Logicbeginner
Combine conditions with AND and OR
=IF(AND(B2="Active",C2>1000),"Qualify","Skip")
Conditional Logic
Conditional Logic formulas
Build formulas that branch cleanly when different business rules or thresholds apply.
Conditional Logicintermediate
Evaluate multiple conditions with IFS
=IFS(A2>=10000,"Gold",A2>=5000,"Silver",A2>=1000,"Bronze",TRUE,"Standard")
Conditional Logicintermediate
Match a value against exact cases with SWITCH
=SWITCH(A2,"N","North","S","South","E","East","W","West","Unknown")
Conditional Logicbeginner
Nested IF grade scale
=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))
Frequently asked questions
Can I nest AND inside OR?
Yes — =IF(OR(AND(B2="A",C2>5),D2="VIP"),"Yes","No") is valid. B2 must be "A" AND C2>5 satisfies the OR, as does D2="VIP" alone.
How many conditions can IFS evaluate?
IFS supports up to 127 condition-result pairs. In practice, more than 5–7 tiers suggest a lookup table may be a better approach.
When should I use SWITCH instead of IFS?
Use SWITCH when you are comparing one expression against multiple exact values. Use IFS when each condition is a different comparison (greater than, less than, contains, etc.).
Should I use IFS instead?
If your Excel version supports IFS, it is usually easier to read and maintain than multiple nested IF calls.