SWITCH function

 The SWITCH function 

Syntax:

SWITCH(expression, value1, result1, [value2, result2], ... [default_result])

How it works:

1. The function evaluates the expression and compares it to the value arguments.

2. If the expression matches a value, the function returns the corresponding result.

3. If no match is found, the function returns the default result (if provided).

4. If no default result is provided and no match is found, the function returns a #N/A error.

Example:

SWITCH(A1, "Red", "Apple", "Green", "Grass", "Unknown")

- If cell A1 contains "Red", the function returns "Apple".

- If cell A1 contains "Green", the function returns "Grass".

- If cell A1 contains any other value, the function returns "Unknown".

Benefits:

1. Simplifies complex IF statements.

2. Easy to read and maintain.

3. Flexible with multiple value-result pairs.

Common uses:

1. Data validation and cleaning.

2. Conditional formatting.

3. Data transformation and mapping.

Supported versions:

1. Excel 2019 and later.

2. Google Sheets.

3. LibreOffice Calc.

Note: In earlier Excel versions, use the IF or LOOKUP functions as alternatives.