Formula Switch for Excel 365 - learnit

Home Top Ad

Post Top Ad

Saturday, August 27, 2022

Formula Switch for Excel 365

Formula Switch for Excel 365

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

Post Top Ad