How to Use IF and Percentage Formula in Excel (2 Easy Ways)

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.

Dataset to Use IF and Percentage Formula in Excel

  • Next, insert the following formula in cell E5.
=(D5-C5)/C5

Inserting Formula to Use IF and Percentage Formula in Excel

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

Using Fill Handle Option to Use IF and Percentage Formula in Excel

  • Furthermore, you will get the desired result.

Final Result to Use IF and Percentage Formula in Excel

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

Converting Numbers into Percentage to Use IF and Percentage Formula in Excel

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

Results in Percentage Form to Use IF and Percentage Formula in Excel

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

Dataset to Use IF and Percentage Formula in Excel

  • Second, insert the following formula in cell E5.
=(D5-C5)

Dataset to Use IF and Percentage Formula in Excel

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

Using Fill Handle Option to Use IF and Percentage Formula in Excel

  • Forth, you will get the desired result.

Final Result to Use IF and Percentage Formula in Excel

  • 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

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo