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.

**Read More: **Advanced Uses of CHOOSE Function in Excel

## 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}**

**Read More:** How to Use VLOOKUP with CHOOSE Function in Excel

## 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**

## 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.

## Related Articles

- How to Use CHOOSE Function with Array in Excel
- Use RANDBETWEEN with CHOOSE Function in Excel
- How to Use CHOOSE Function in Excel for Scenarios
- How to Apply CHOOSE Function to Create Drop-Down List in Excel
- How to Use Excel Formula to Choose Between Two Values

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