Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelSwitch Function in Excel

# Switch Function in Excel

In this post, youâ€™ll learn about one of the conditional statements in Excel called Switch and how you can use Switch function in your Excel spreadsheet.

## What is the use of Switch Function in Excel?

The ExcelÂ Switch functionÂ compares one value against a list of values and returns a result corresponding to the first match. The switch function can return an optional default value when no match is found.

The following steps will explain the work of Switch Function in Excel:

• First, prepare anÂ excel sheetÂ with the required details in it.

To check the Search Function condition use the following formula:

`=SEARCH(expression, value1,result1,[value2,result2],[value3,result3],[default_or_value4,result4],[default_or_value5,result5],[default_or_value6,result6,.....) `

or for better understanding

`=SEARCH(B2,1,"Poor",2,"Ok",3,"Good","??").`

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021