SWITCH()

Description

Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met.

How To Use in Sheets

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

External Links

SWITCH Function (Multiple IF conditions, IFS function) - Google Sheets - similar in Excel

Learn how to use SWITCH function in Google Sheets or Excel to create multiple If statements. Understand the difference between SWITCH & IFS functions. Function covered in this tutorial: SWITCH, IFS, DGET, YEAR, MONTH