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

**Table of Contents**hide

## Download Practice Workbook

## 5 Examples of Using CHOOSE Function to Perform IF Condition in Excel

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

### 1. Return Different Values Using 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**Grade**. - Then, drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

Here, in 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.

**Read More:** **How to Use Excel Formula to Choose Between Two Values**

### 2. Apply 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 **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**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**IF calculation**using the**CHOOSE Function**.

**Read More: How to Apply CHOOSE Function to Create Drop-Down List in Excel**

### 3. Insert CHOOSE Function to Sum Values with IF Condition

In the third method, you will find a way to **sum **value with **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**in**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 (9 Applications)**

### 4. Use 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 **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. Return Day or Month Performing IF Condition with CHOOSE Function

Finally, you can also return **Day **or **Month **performing **IF condition **with 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**.

**Read More:** **How to Use CHOOSE Function in Excel for Scenarios**

## Practice Section

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

## 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. Please let us know if there are any more alternatives that we may have missed. And, visit **ExcelDemy** for many more articles like this. Thank you!