What is SWITCH Function in Excel?
The SWITCH function is one of the Logical functions of Excel.
It 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 is returned.
We can find this function in the Logical of insert function Tab.
How to use SWITCH function in excel
1. Click on empty cell (like F5 )
2. Click on the fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select Logical category
5. Select SWITCH function
6. Then select ok
7. In the function arguments Tab you will see the SWITCH function
8. Expression section is an expression to be evaluated
9. In Value1 section we can enter a value to be compared with the expression
10. In Result1 section we can enter a result to be returned if the corresponding value matches the expression
11. Default_or_value2 is a value to be compared with the expression
12. In Result2 section we can enter a result to be returned if the corresponding value matches
the expression
13. You will see the result in formula result section
Examples of SWITCH function in excel
What is the purpose of SWITCH function?
What is the Return value of SWITCH function?
How many arguments does SWITCH function have?
This function has just 1 Argument.
The argument of ABS function is number.
The argument of ABS function is required and not optional.
Which version of excel supports SWITCH function?
This function is available for all excel versions (2003-2019)
Errors in SWITCH function
SWITCH related functions
- IF function
- IFS function
- CHOOSE function
- VLOOKUP function
- MATCH function
