Code to label
| A | |
|---|---|
| 1 | Code |
| 2 | W |
Formula: C1: =SWITCH(A2,"E","East","W","West","N","North","Unknown")
Result: West
A2 is compared with each code in turn; the last lone argument is the default.
Google Sheets function
SWITCH in Google Sheets
SWITCH with worked examples you can test in the live grid. The argument details are in the Excel guide.
In Google Sheets
The arguments and common errors are covered in the SWITCH Excel guide; check the function help in Google Sheets for its own argument list.
Worked examples in Google Sheets
Weekend or weekday
| A | |
|---|---|
| 1 | Date |
| 2 | 3/9/2024 |
Formula: C1: =SWITCH(WEEKDAY(A2),1,"Sun",7,"Sat","Weekday")
Result: Sat
WEEKDAY returns 7 for Saturday, so the second pair matches. March 9, 2024 is a Saturday.
Ranges by switching on TRUE
| A | |
|---|---|
| 1 | Units |
| 2 | 75 |
Formula: C1: =SWITCH(TRUE,A2<50,"Low",A2<100,"Mid","High")
Result: Mid
Each test returns TRUE or FALSE; SWITCH picks the first one that equals TRUE.
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in F2: =SWITCH(C2,"Yes","Bonus","No","None","Other")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Student | Score | Extra credit | Attempts | Result | |
| 2 | Ann | 92 | Yes | 2 | Bonus | |
| 3 | Bob | 74 | No | 0 | ||
| 4 | Cy | 58 | Yes | 3 | ||
| 5 | Dee | 81 | No | 1 | ||
| 6 | Eli | 66 | 2 |
Result in F2: Bonus
Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.