SWITCH

The SWITCH function evaluates an expression against a list of values and returns the result corresponding to the first matching value. If no match is found, an optional default value is returned.

Syntax#

SWITCH(expression, val1, res1, val2, res2, ..., val_n, res_n, default)

Arguments#

• expression: The expression to evaluate.
• val1, val2, … val_n: The values to compare against the expression.
• res1, res2, … res_n: The result to return for each matching value.
• default (Optional): The value to return if no match is found.

Return value#

Returns the result corresponding to the first matching value. If no match is found, returns the default value (if specified).

Example#

SWITCH(Sub-Category, "Bookcases", 4.55, "Chairs", 2.67, "Tables", 2.81, "Art", 1.35, 
"Paper", 3.79, "Machines", 10.55, "Envelopes", 1.23, "Storage", 2.53, 0)

Evaluates the Sub-Category value and returns the corresponding numeric value for each match; if no match is found, returns 0.

Excel equivalent#

SWITCH