SWITCH function in Excel

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 )

Click on empty cell excel

2. Click on the fx icon (or press shift+F3)

the fx icon excel

3. In the insert function tab you will see all functions

insert function tab excel

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

How to use SWITCH function in excel

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

Leave a Reply

Your email address will not be published. Required fields are marked *