The Right Way to Use SWITCH Function in Excel

The SWITCH function is one of the Logical functions in Excel. The SWITCH function allows you to compare an expression to a list of values and return the corresponding result to illustrate how to use the SWITCH function, let’s look at an example Here we have a list of topics Let’s use the SWITCH function to return a specific website for each topic.

To get started, let’s begin by entering the SWITCH command. As you can see, the SWITCH function takes a series of parameters. The first parameter you must enter is the expression that you will compare to a list of values. In this example, let’s enter A2 as our expression Cell A2 contains the value “Minecraft”. The next parameters we will need to enter is a list of values and their corresponding result. Each of the values will be compared to the expression and once the first value is found that matches the expression the corresponding result will be returned.

You can enter one or more of these result/value pairs. In this example, we will enter two pairs for the first pair, we will enter “Excel” and “tipa”. For the second pair, we will enter “Minecraft” and “tipa.in”. The third parameter is optional. It is the default value to return if the expression was not found in the previous list of values. In this example we will enter a default value of “Unknown”. Now that we have entered all of the parameters for the SWITCH function let’s complete the command to look at our result You should see the value ” tipa.in” appear in cell C2.

This is the website that is paired with the topic of Minecraft. Now let’s copy our formula into cell C3 and C4. Each of these cells now contain the corresponding SWITCH value for its topic In cell C3, you should see the value ” tipa.in”. This is the value returned by the SWITCH function when the topic is Excel and finally in cell C4, you should see the value “Unknown”. Since the topic “Weather” is not found in the list of values in the SWITCH function the default value of “Unknown” is returned.

This completes our example of how to use Excel’s SWITCH function. If you want to learn more excel function then join institute of professional accountant advanced excel training and learn every function of excel. In case of any query call us at +91-9312855555.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create your website at WordPress.com
Get started
%d bloggers like this: