This Excel tutorial explains how to use the Excel SWITCH function with syntax and examples.
The SWITCH function in Microsoft Excel compares an expression to a list of values and returns the corresponding result.
The SWITCH function is an Excel built-in function that is classified as a Logical Function. It can be used in Excel as a worksheet function (WS). The SWITCH function is a worksheet function that can be used as part of a formula in a worksheet cell.
If you are looking for the VBA version of the SWITCH function, please read our SWITCH function (VBA) page as it has a very different syntax.
Syntax
The syntax for the SWITCH function in Microsoft Excel is:
SWITCH ( expression, value1, result1, value2, result2, ... value_n, result_n [, default] )
Parameters or Arguments
expression
    The expression to compare to a list of values.
value1, value2, ... value_n
    A list of values that are compared to expression. The SWITCH function is looking for the first value that matches the expression.
result1, result2, ... result_n
    A list of results. The SWITCH function returns the corresponding result when a value matches expression.
default
    Optional. It is the default to return if expression does not match any of the values (value1, value2, ... value_n).
Please Watching My Video is Below
No comments:
Post a Comment