Conditional Logicintermediate
Evaluate multiple conditions with IFS
=IFS(A2>=10000,"Gold",A2>=5000,"Silver",A2>=1000,"Bronze",TRUE,"Standard")
Excel how-to guide
How to switch exact match in Excel
Translate a status code into a label, map a region abbreviation to a full name, or convert a number to a day or month name.
Step-by-step instructions
How to switch exact match — 3 steps
1
Enter the expression to evaluate — usually a cell reference — as the first argument.
2
List value-result pairs — the value to match followed by what to return if it matches.
3
Add a final default value after all pairs to handle unmatched inputs instead of returning
Example data
Worked example
| Code | Region Name |
|---|---|
| N | North |
| S | South |
| E | East |
| X | Unknown |
Common mistakes
Errors to watch out for
SWITCH returns
No value matched and no default was provided. Add a final argument after the last value-result pair to serve as the default — SWITCH(A2,"A","Alpha","B","Beta","Unknown").
SWITCH is not available
SWITCH requires Excel 2019 or Excel 365. Use nested IFs or an INDEX/MATCH lookup table for older versions.
FAQ
Frequently asked questions
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.).
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"))))