★0 XP
Question 1 of 10
The SWITCH function in Excel compares a value to a list of possible match/result pairs and returns the result of the appropriate match. Say you wanted each number spelled out rather than in numerical form. Type in this formula to reference the value in cell A1, and return the matching result of "One."
=SWITCH(A1, 1, "One")
=SWITCH(A1, 1, "One")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 1 | |||
| 2 | 2 | |||
| 3 | 3 | |||
| 4 | 4 | |||
| 5 | 5 |
B1fx