How to Use CHOOSE Function to Perform IF Condition in Excel

Looking for ways to use the CHOOSE function to perform the IF condition in Excel? Then, this is the right place for you. We can use the CHOOSE function to choose between different data for different conditions. Here, you will find 5 different examples of using the Excel CHOOSE function to perform the IF condition.

Going through the following examples you can easily perform the IF condition in your dataset in Excel using the CHOOSE function.

1. Returning Different Values Using the CHOOSE Function in Excel

In the first example, we will show you how you can return different values using the CHOOSE function in Excel. Here, we have a dataset containing the Name and Score of some students.

Now, we will use the CHOOSE function to perform the IF condition to find the corresponding Grade for the given Score. Follow the steps given below to do it on your own.

Steps:

Firstly, select cell D5 and insert the following formula.

=CHOOSE((C5>0)+(C5>=50)+(C5>=60)+(C5>=70)+(C5>=80), "F", "D", "C", "B","A")

After that, press Enter to get the value of the Grade.
Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Here, the CHOOSE function will check if cell C5 is greater than 0 then it will return F, then, if the value is greater or equal to 50 it will return D. Similarly, according to the given condition it will return C, B, or A.

Finally, you will get different return values using the CHOOSE function.

2. Applying Excel CHOOSE Function to Perform Different IF Calculations

Now, we will apply the Excel CHOOSE function to perform different IF calculations. Here, we have a dataset containing the Name of the Salesperson and their Sales value. Suppose, they will get a Commission depending on the number of their Sales.

In this case, you can calculate the amount of Commission for different Sales values using the CHOOSE function.

Steps:

In the beginning, select cell D5 and insert the following formula.

=CHOOSE((C5>0)+(C5>300)+(C5>=600),C5*5%,C5*10%,C5*15%)

Then, press Enter to get the value of the Commission.
After that, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Here, the CHOOSE function will check if cell C5 is greater than 0 then it will multiply the value of Cell C5 by 5%, then, if the value is greater than 300 it will multiply the value of cell C5 by 10% and if the value is greater than or equal to 600, it will multiply the value of cell C5 by 15%.

Finally, you will get different values after performing the IF calculation using the CHOOSE function.

3. Inserting CHOOSE Function to Sum Values with IF Condition

In the third method, you will find a way to sum value with the IF condition using the CHOOSE function in Excel.

Here, we have a dataset containing the Sales value of January, February, and March of some Products. Now we will show you how you can sum the Sales value of January using the SUM and CHOOSE functions.

Steps:

Firstly, select Cell C10 and insert the following formula.

=SUM(CHOOSE(1,C5:C8,D5:D8,E5:E8))

Then, press Enter to get the value of Total Sales (January).

Here, in the CHOOSE function, we inserted 1 as index_num and cell range C5:C8, D5:D8, and E5:E8 as value. Then, the SUM function will add the values returned by the CHOOSE function.

4. Using the CHOOSE Function to Perform IF Condition to VLOOKUP Values in Excel

Next, we will show you how you can use the CHOOSE function to perform the IF condition to VLOOKUP values in Excel.

Suppose, you have a dataset containing the Name and Score of some students. Now, we will show you how to VLOOKUP the Score of any student using their Name by applying the VLOOKUP and CHOOSE functions.

Steps:

In the beginning, select cell C15 and insert the following formula.

=VLOOKUP(B15,CHOOSE({1,2},B5:B12,C5:C12),2,0)

After that, press Enter to get the Score of the student.

🔎 How does the Formula Work?

CHOOSE({1,2},B5:B12,C5:C12)—–> The CHOOSE function returns the value from a list using the specific given position.

Output: {“Liam”,34;”Jack”,78;”Harry”,56;”Emma”,67;”Bela”,88;”Henry”,50;”Lucy”,90;”Mike”,73}

VLOOKUP(B15,CHOOSE({1,2},B5:B12,C5:C12),2,0)—–> The VLOOKUP function returns the Vlookup values from a given Cell range according to the given column index.

VLOOKUP(B15,{“Liam”,34;”Jack”,78;”Harry”,56;”Emma”,67;”Bela”,88;”Henry”,50;”Lucy”,90;”Mike”,73},2,0)—–> turns into

Output: {73}

5. Returning Day or Month Performing IF Condition with CHOOSE Function

Finally, you can also return Day or Month performing IF condition with the Excel CHOOSE function.

Here, using the dataset given below we will show you how you can find the corresponding Day and Month of the given Dates using the CHOOSE function.

Steps:

Firstly, select cell C5 and insert the following formula.

=CHOOSE(MONTH(B5), "Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

After that, press Enter to get the value of the Month.
Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Here, using the MONTH function we find out the month value of the given date. Then, the CHOOSE function returned the month value from the given list.

Now, you will get all the values of the Month.

Next, select cell D5 and insert the following formula.

=CHOOSE(WEEKDAY(B5),"Sun","Mon","Tue","Wed","Thurs","Fri","Sat")

Then, press Enter to get the value of Day.
After that, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Here, using the WEEKDAY function we find out the day value of the given date. Then, the CHOOSE function returned the day value from the given list.

Finally, you will get all the values of Day.

Practice Section

In the article, you will find an Excel workbook like the image given below to practice on your own.

Download Practice Workbook

Using CHOOSE Function to Perform IF Condition.xlsx

Conclusion

So, in this article, we have shown you ways of using the CHOOSE function to perform the IF condition in Excel. I hope you found this article interesting and helpful. If something seems difficult to understand, please leave a comment.

<< Go Back to Excel CHOOSE Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

How to Use CHOOSE Function to Perform IF Condition in Excel

1. Returning Different Values Using the CHOOSE Function in Excel

2. Applying Excel CHOOSE Function to Perform Different IF Calculations

3. Inserting CHOOSE Function to Sum Values with IF Condition

4. Using the CHOOSE Function to Perform IF Condition to VLOOKUP Values in Excel

5. Returning Day or Month Performing IF Condition with CHOOSE Function

Practice Section

Conclusion

Related Articles

Leave a reply Cancel reply