Percentage Calculation with Excel Formula

Learn how to calculate a percentage in Excel with step-by-step instructions. Understand the percentage formula and other formulas like SUMPRODUCT and CONVERT that can help you calculate percentages quickly and accurately. Master the art of Excel to be more efficient in data analysis and presentations.


Tired of nonsense pricing of DocuSign?

Start taking digital signatures with BoloSign and save money.

Knowing how to calculate a percentage in Excel is an essential skill for anyone who works with data or numbers. Being able to quickly and accurately calculate percentages can help you be more efficient when analyzing data or presenting information. The good news is, it's actually quite easy to do!

The most common way to calculate a percentage in Excel is to use the percentage formula. This formula requires two values - the numerator and the denominator - and then divides them to provide the desired result. For example, if you want to calculate 20% of 500, you would use the formula =500*20%.

You can also use the original value as the denominator and the percentage as the numerator. For example, if you have a number such as 500 and want to find what 20% of that number is, you would use the formula =500/20%.

In addition to the percentage formula, there are other formulas that can be used for percentage calculations. The SUMPRODUCT function is often used for calculating percentages from multiple cells. For example, if you have a range of cells with prices, you can use SUMPRODUCT to calculate the percentage of each price compared to the total.

The CONVERT function can also be used to convert a number into a percentage format. For example, if you have a value such as 2.5 and want to express it as a percentage, you can use the CONVERT function to convert it to 250%.

Once you understand how to use these formulas, calculating percentages in Excel is easy. That said, it's important to practice so that you become familiar with the different formulas and how to use them correctly.


Paresh Deshmukh

Co-Founder, BoloForms

18 Feb, 2023

Take a Look at Our Featured Articles

These articles will guide you on how to simplify office work, boost your efficiency, and concentrate on expanding your business.