This tutorial will demonstrate how to use the **IF** and **Percentage formulas in excel**. In Microsoft Excel, we can use different methods to calculate the percentage of a numeric value with a formula. We can apply algebraic calculations or insert a function to meet our objectives. When you are performing complicated and powerful data analysis, you need to justify various conditions at a single point in time. In Microsoft Excel, **the IF function** acts as a powerful tool to work on conditions. In this article, you will learn how to use the IF and Percentage formulas in excel.

## Download Practice Workbook

You can download the practice workbook from here.

## 2 Easy Examples to Use IF and Percentage Formula in Excel

We’ll use a sample dataset overview as an example in Excel to understand easily. If you follow the steps correctly, you should learn how to use **the IF and Percentage** formulas in excel on your own. The steps are:

### 1. Using IF Function Via Percentage Column

In this case, our goal is to learn how to use **the IF** and **Percentage** formulas. We can learn this by first creating a **percentage** column and then using it under a certain condition. To use percentage form, we have to learn to convert a normal numeric value into a percentage. Technically Excel will convert any input data into a percentage by multiplying it by 100 and adding a percentage symbol (%) on the right if you opt to choose percentage formatting. But you can also convert a number directly to a percentage value without letting it be multiplied by 100 in Excel. After that, you can easily insert the particular condition using **the IF function**. The steps of this method are as follows.

**Steps:**

- First, arrange the dataset like the below image.

- Next, insert the following formula in cell
**E5**.

`=(D5-C5)/C5`

- After that, after pressing the
**Enter**button, you will get the result for this cell. Moreover, use the**Fill Handle**option to use the formula for all the cells.

- Furthermore, you will get the desired result.

- Afterward, select the whole column and go to the
**Home**tab, and in the**Number Format**section select the**Percentage**option.

- Moreover, you will get the desired result in the percentage form like the below image.

- Then, insert the following formula in cell
**F5**.

`=IF(E5>0,"Good","Fail")`

- In addition, after pressing the
**Enter**button, you will get the result for this cell. Moreover, use the**Fill Handle**option to use the formula for all the cells.

- Finally, you will get the desired result.

**Read More: ****How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)**

### 2. Use of IF and Percentage Altogether in One Column

Now, we want to use the **IF** and **Percentage **formulas together in a column to determine a certain value. In Microsoft Excel, **the IF function** is used to check if a condition is met and then the defined statements will be shown based on the given condition. In this article, you’ll learn how you can use **this IF function** efficiently with different criteria and by combining it with other functions in Excel. After using **the IF function** with the proper conditions, you can convert the numeric value into a percentage. The steps of this method are as follows.

**Steps:**

- First, arrange the dataset like the below image.

- Second, insert the following formula in cell
**E5**.

`=(D5-C5)`

- Third, after pressing the
**Enter**button, you will get the result for this cell. Moreover, use the**Fill Handle**option to use the formula for all the cells.

- Forth, you will get the desired result.

- Fifth, insert the following formula in cell
**F5**.

`=IF(E5>0,(E5/C5),"Fail")`

- Sixth, after pressing the
**Enter**button, you will get the result for this cell. Moreover, use the**Fill Handle**option to use the formula for all the cells.

- Seventh, you will get the desired result.

- Eighth, to convert the numeric values into percentages, select the whole column and go to the
**Home**tab, and in the**Number Format**section select the**Percentage**option.

- Last, you will get the desired result.

**Read More: ****How to Calculate Percentage of a Number in Excel (5 Easy Ways)**

## Things to Remember

- In the case of using the functions, we must focus on the conditions properly. If the condition isn’t written properly then the desired result won’t be found.
- Initially, after using a formula, you will get the result in numeric form. So, you have to convert the numeric values into percentage form manually.
- We suggest you download the excel file and see it while using the formulas for better understanding.

## Conclusion

Henceforth, follow the above-described methods. Hopefully, these methods will help you to use if percentage formula in excel. We will be glad to know if you can execute the task in any other way. Follow the **ExcelDemy** website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our level best to solve the problem or work with your suggestions.

## Related Articles

**Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Average Percentage in Excel (3 Easy Methods)****Use Excel Formula to Calculate Percentage of Grand Total****How to Add 10 Percent to a Number in Excel (2 Easy Methods)****Calculate Cumulative Percentage in Excel (6 Easy Methods)****How to Calculate Total Percentage in Excel (5 Ways)****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)**