Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: SWITCH function

SWITCH function: Description, Usage, Syntax, Examples and Explanation

What is SWITCH function in Excel? SWITCH function is one of the Logical functions in Microsoft Excel that evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. Syntax of SWITCH function In its simplest form, the SWITCH function says:…

SWITCH function example in Excel

Excel SWITCH function compares an expression to a list of values and returns the corresponding result. This example teaches you how to use the SWITCH function in Excel 2016 instead of the IFS function. 1a. For example, the IFS function below finds the correct states. Explanation: cell A2 contains the string 85-UT. The RIGHT function extracts the 2 rightmost characters from this string (UT).…