LXLogicExcel
🔥
0
0
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")
ABCD
11
22
33
44
55
B1fx
🔥0streak
0 XP today
All Lessons