SWITCH practice

SWITCH compares a value against a list of cases and returns the matching result. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

SWITCH(expression, case1, value1, [case2, value2], ..., [default])

What people get wrong

Cleaner than nested IFs when one cell is compared with several exact values, such as region codes.

Google Sheets exercise that use SWITCH

• Region names with SWITCHLevel 2Pro