SWITCH: match a value
Exercise 1 of 3
Size code 1 is Small, 2 is Medium and 3 is Large. In C2, turn the code into its size.
About this lesson
SWITCH compares one value with a list and returns the matching result, a neat way to turn codes into names.
In this lesson
- Size code 1 is Small, 2 is Medium and 3 is Large. In
C2, turn the code into its size. - North gets a 10% discount and South 15%. Every other region gets 0. In
B2, work out the discount for the region inA2. - Now work out the discount for East in
B4.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in C2 and press Enter to check.