SWITCH Function
Use SWITCH function for value matching.
Task:
You are converting day numbers to day names for a scheduling application. Convert day numbers to day names using SWITCH in column B, where 1=Monday, 2=Tuesday, etc.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of SWITCH
0/4The same formula in the other shapes it takes at work.
- SWITCH Function
Use SWITCH function for value matching.
CoreAdvanced - SWITCH for text codes, with a default
Turn a one-letter code into a word, and say so when the code is unknown.
Intermediate - SWITCH returning a number inside a calculation
Look the tier's multiplier up and apply it in the same formula.
Advanced - SWITCH(TRUE, …) for ranges
Switch on TRUE and each "match" becomes a condition.
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Day Number | Day Name |
| 2 | 1 | |
| 3 | 3 | |
| 4 | 5 | |
| 5 | 7 | |
| 6 | 2 |
Functions used here
What this exercise teachesMay contain the answer
SWITCH function is ideal for scenarios where you need to match an expression against several exact values and return a corresponding result, often cleaner than multiple IFs for this purpose.