SWITCH function 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… read more »