Conditional Logicintermediate
Match a value against exact cases with SWITCH
=SWITCH(A2,"N","North","S","South","E","East","W","West","Unknown")
Excel how-to guide
How to ifs multiple conditions in Excel
Assign a discount tier based on order size, map a numeric score to a letter grade, or classify customers into segments by revenue band.
Step-by-step instructions
How to ifs multiple conditions — 3 steps
1
List each condition followed by its result value — they are evaluated left to right.
2
Order conditions from most restrictive to least restrictive so the first match is always the correct one.
3
Use TRUE as the final condition to act as a catch-all default — IFS has no built-in else.
Example data
Worked example
| Revenue | Tier |
|---|---|
| 12000 | Gold |
| 6500 | Silver |
| 2200 | Bronze |
| 400 | Standard |
Common mistakes
Errors to watch out for
IFS returns
IFS has no built-in default. Add TRUE as the last condition with the fallback value — IFS(...,TRUE,"Default") — to prevent #N/A when no condition is met.
Wrong tier returned
IFS returns the result for the first TRUE condition. If conditions overlap, order them from highest threshold to lowest so the correct tier matches first.
FAQ
Frequently asked questions
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.
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides
Continue learning.
Conditional Logicbeginner
Nested IF grade scale
=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))