Learn how to use the SWITCH function in Excel to evaluate one value against a list of values and return the corresponding result. See examples, technical details, and related functions.

The Switch function argument list consists of pairs of expressions and values. The expressions are evaluated from left to right, and the value associated with the first expression to evaluate to True is returned.

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. Evaluates an 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.

Lists all Excel functions by their category, such as Logical functions or Text functions.

La funzione SWITCH valuta un valore, chiamato espressione, rispetto a un elenco di valori e restituisce il risultato che equivale al primo valore corrispondente. Se non ci sono valori corrispondenti, verrà restituito un valore predefinito facoltativo.

Die SWITCH-Funktion wertet einen Wert (als Ausdruck bezeichnet) anhand einer Liste von Werten aus und gibt das Ergebnis zurück, das dem ersten übereinstimmenden Wert entspricht. Wenn es keine Übereinstimmung gibt, kann ein optionaler Standardwert zurückgegeben werden.

SWITCH 函数根据值列表计算一个值（称为 表达式），并返回与第一个匹配值对应的结果。 如果不匹配，则可能返回可选默认值。 注意: 如果具有 Office 2019 或 Microsoft 365 订阅，则可在 Windows 或 Mac 上使用此功能。

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type a formula instead using the TRANSPOSE function.

For example, if you select a function, you must select the entire function name, the opening parenthesis, the arguments, and the closing parenthesis. To calculate the selected portion, press F9. To replace the selected portion of the formula with its calculated value, press ENTER.