5 Excel Percentage Formulas

Introduction to Excel Percentage Formulas

Excel is a powerful tool used for various calculations, including percentage calculations. Percentage calculations are used to determine the proportion of a whole as a fraction of 100. In this article, we will explore five essential Excel percentage formulas that can be used to perform different percentage calculations.

1. Calculate Percentage of a Number

To calculate a percentage of a number, you can use the formula: =number*percentage. For example, if you want to calculate 20% of 100, you can use the formula: =100*20% or =100*0.2. This formula will return the result 20.

2. Calculate Percentage Increase

The formula to calculate the percentage increase between two numbers is: =((new number - old number) / old number)*100. For example, if the old number is 100 and the new number is 120, the formula will be: =((120 - 100) / 100)*100, which returns 20%.

3. Calculate Percentage Decrease

To calculate the percentage decrease between two numbers, you can use the formula: =((old number - new number) / old number)*100. For example, if the old number is 100 and the new number is 80, the formula will be: =((100 - 80) / 100)*100, which returns 20%.

4. Calculate the Percentage of Total

To calculate the percentage of total, you can use the formula: =(part/whole)*100. For example, if you want to calculate the percentage of a specific category in a dataset, you can use this formula. Suppose the part is 20 and the whole is 100, the formula will be: =(²⁰⁄₁₀₀)*100, which returns 20%.

5. Calculate the Difference as a Percentage

To calculate the difference between two numbers as a percentage, you can use the formula: =(difference / old number)*100. For example, if the old number is 100 and the new number is 120, the difference is 20. The formula will be: =(20 / 100)*100, which returns 20%.

📝 Note: These formulas can be applied to various real-world scenarios, such as calculating the percentage increase in sales, the percentage decrease in expenses, or the percentage of a specific product in a portfolio.

In addition to these formulas, Excel also provides a PERCENTAGE format that can be applied to cells to display the value as a percentage. To apply this format, select the cell, right-click, and select Format cells. Then, in the Number tab, select Percentage and click OK.

Formula	Description
=number*percentage	Calculate percentage of a number
=((new number - old number) / old number)*100	Calculate percentage increase
=((old number - new number) / old number)*100	Calculate percentage decrease
=(part/whole)*100	Calculate percentage of total
=(difference / old number)*100	Calculate difference as a percentage

To master these formulas, practice using them in different scenarios. With time and practice, you will become proficient in using these formulas to perform various percentage calculations in Excel.

In summary, the five Excel percentage formulas discussed in this article are essential tools for performing different percentage calculations. By mastering these formulas, you can efficiently calculate percentages, percentage increases, percentage decreases, percentages of totals, and differences as percentages. This will enable you to make informed decisions and analyze data effectively.