How to Calculate Percentage in Excel with Simple Formulas

Published 26 July 2026

Kicking off with how to calculate percentage in excel, this article will walk you through the process step-by-step, from basic to advanced calculations. Learn how to apply percentage formulas to real-world scenarios, avoid common mistakes, and visualize percentage data in Excel.

Whether you're a beginner or an experienced user, this guide will provide you with the knowledge and skills to calculate percentages confidently. With this knowledge, you'll be able to create a basic percentage calculator in Excel and use it to make informed decisions in business and finance.

Calculating Percentage in Excel using Formula Basics

Calculating percentages is a crucial skill in Microsoft Excel, especially in business and finance where it's essential to track and compare different values. In this article, we'll explore the basics of percentage formulas in Excel, provide examples and step-by-step guides for various calculations, and discuss the importance of understanding percentage calculations in business and finance.

Basic Percentage Formulas

The most common percentage formula in Excel is the formula for finding a percentage of a total value. To calculate a percentage of a value, you can use the formula:

Percentage = (Value / Total) 100

For example, suppose you want to calculate a 20% commission on a sale of $100, you can use the following formula:

Commission = (20 / 100) 100

Percentage of a Total Value

To find a percentage of a total value, you can use the same formula:

Percentage = (Value / Total) 100

For example, suppose you want to calculate a 20% increase in sales from $100,000 to $120,000:

Percentage Increase = (($120,000 - $100,000) / $100,000) 100

Percentage Decrease

To find a percentage decrease, you can use the following formula:

Percentage Decrease = ((Original Value - New Value) / Original Value) 100

For example, suppose you want to calculate a 15% decrease in sales from $100,000 to $85,000:

Percentage Decrease = (($100,000 - $85,000) / $100,000) 100

Average Percentage

To find the average percentage of multiple values, you can use the following formula:

Average Percentage = ( (Value 1 + Value 2 + ... + Value N) / N ) 100

For example, suppose you want to calculate the average sales growth of 10 different products, with sales values $1000, $1200, $900, $1100, $1300, $1400, $800, $1000, $1200, $900:

Average Sales Growth = ( (1000 + 1200 + 900 + 1100 + 1300 + 1400 + 800 + 1000 + 1200 + 900) / 10) 100

Percentage Change Over Time

To find the percentage change over time, you can use the following formula:

Percentage Change = ((Final Value - Initial Value) / Initial Value) 100

For example, suppose you want to calculate the percentage change in sales from $100,000 in 2020 to $120,000 in 2021:

Percentage Change = (($120,000 - $100,000) / $100,000) 100

Ranking by Percentage

To rank items by percentage, you can use the following formula:

Rank = RANK.EQ(

,

,

<[0 or 1]>

)

For example, suppose you want to rank the sales growth of 10 different products by percentage:

Rank = RANK.EQ(A2, A2:A11, 0)

Percentage Difference Between Two Percentages

To find the percentage difference between two percentages, you can use the following formula:

Percentage Difference = ( (Percentage 1 - Percentage 2) / (Percentage 1 + Percentage 2) ) 100

For example, suppose you want to find the percentage difference between two sales growth rates, 20% and 30%:

Percentage Difference = ( (20 - 30) / (20 + 30)) 100

Percentage Increase from a Previous Value

To find the percentage increase from a previous value, you can use the following formula:

Percentage Increase = ((Value - Previous Value) / Previous Value) 100

For example, suppose you want to calculate the percentage increase in sales from $100,000 to $120,000:

Percentage Increase = (($120,000 - $100,000) / $100,000) 100

Percentage Decrease from a Previous Value

To find the percentage decrease from a previous value, you can use the following formula:

Percentage Decrease = ((Previous Value - Value) / Previous Value) 100

For example, suppose you want to calculate the percentage decrease in sales from $100,000 to $85,000:

Percentage Decrease = (($100,000 - $85,000) / $100,000) 100

Percentage Increase Over Time, How to calculate percentage in excel

To find the percentage increase over time, you can use the following formula:

Percentage Increase = ((Final Value - Initial Value) / Initial Value) 100

For example, suppose you want to calculate the percentage increase in sales from $100,000 in 2020 to $120,000 in 2021:

Percentage Increase = (($120,000 - $100,000) / $100,000) 100

Ranking by Percentage Increase

To rank items by percentage increase, you can use the following formula:

Rank = RANK.EQ(

,

,

<[0 or 1]>

)

For example, suppose you want to rank the sales growth of 10 different products by percentage:

Rank = RANK.EQ(A2, A2:A11, 0)

Applying Percentage Formulas to Real-World Scenarios: How To Calculate Percentage In Excel

Calculating percentages is a crucial skill in everyday life, and Excel makes it easier with its robust formula capabilities. Whether you're a student, a professional, or simply an Excel enthusiast, understanding how to apply percentage formulas in real-world scenarios is essential.

Calculating discounts and sales taxes are just a couple of examples where percentage formulas come into play. Let's dive deeper into how you can utilize these formulas in various real-world scenarios.

Discounts and Markdowns

Discount = Original Price x (Discount Percentage / 100)

However, in Excel, you can use the following formula:

Discounted Price = Original Price - (Original Price x (Discount Percentage / 100))

For instance, let's say you're shopping for a shirt that originally costs $50 and is on sale for 20% off. You can use the formula:

Discounted Price = 50 - (50 x (20 / 100))

Advanced Percentage Calculations in Excel

Using Excel's Built-in Functions

*

• The PERCENTILE function calculates a specific percentile of a dataset. For example, to calculate the 75th percentile of a dataset, you can use the formula: `=PERCENTILE(A:A, 0.75)`. This will return the value at the 75th percentile.
• The PERCENTRANK function calculates the percentage rank of a value within a dataset. For example, to calculate the percentage rank of a value 'X' within a dataset, you can use the formula: `=PERCENTRANK(A:A, X)`. This will return the percentage rank of 'X' within the dataset.

The PERCENTILE function returns the value in the specified percentile of a range of values.

Using Array Formulas

*

• To calculate the average of a dataset 'A:A' where the values are greater than or equal to 'X', you can use the array formula: `=AVERAGEIFS(A:A, A:A >= X)`. This will return the average of the values in the dataset that are greater than or equal to 'X'.

You want to calculate the average of a range of cells, but first you want to average only the cells that have data.

Using Pivot Tables

*

• Say you have a dataset with sales data by region, and you want to calculate the percentage of total sales by region. You can create a pivot table with the 'Region' as the row label, 'Sales' as the value field, and 'Percentage of Total' as the value field setting.
• In the 'Value Field Settings' dialog box, click on the 'Value Field Settings' button and select 'Percent of Column Total'. This will calculate the percentage of total sales for each region.

You can create a pivot table and analyze your data more easily and efficiently. A pivot table is a powerful tool that allows you to summarize, sort, and analyze large data sets.

Common Mistakes in Calculating Percentages in Excel

Misunderstanding the Formula

The formula for calculating a percentage in Excel is =(Number Percentage/100).

Not Rounding the Result

For instance, when calculating a 10% discount on a price of $100, the correct result would be $10 (=$100 0.10 or 10% of $100). If the result is not rounded, the actual outcome might be $9.99 or $10.01, which can make a difference in real-world scenarios.

Failing to Use the Correct Order of Operations

Imagine you want to calculate 15% of 20% of a value. If you use the formula =(15/100) (20/100) Value, you will get an incorrect result. Instead, use =(15/100) (20/100) (Value 1) to get the correct result.

Not Considering Sign Changes

Suppose you have a value of -$10 with a 10% increase applied. The correct calculation would be =$100 - 10% of -$10, not just $10 + $10 (=$10). Failing to account for sign changes can lead to incorrect results.

Ignoring the Impact of Cell Formatting

Imagine you apply a percentage formula to a cell and then change the cell formatting to a percentage by default. Excel will not update the formula to reflect the new formatting, leading to incorrect calculations.

To avoid this, use the formula =(Amount Percentage/100) and apply the percentage formatting manually to the cell containing the result.

Not Verifying Calculations

To verify your calculations, use a calculator or perform a manual calculation to confirm the result. This ensures that your Excel calculations are accurate and reliable.

Epilogue

In conclusion, calculating percentages in Excel is a valuable skill that can be applied to various real-world scenarios. By understanding the basics of percentage formulas, you'll be able to create a basic percentage calculator in Excel and make informed decisions with confidence. Remember to always check your calculations and avoid common mistakes to ensure accurate results.

Answers to Common Questions

What is the correct formula to calculate a percentage in Excel?

The correct formula to calculate a percentage in Excel is: (cell value / total value) 100.

How do I calculate a discount in Excel?

To calculate a discount in Excel, use the formula: (original price - discount amount) / original price 100.

How do I calculate a percentage change in Excel?

To calculate a percentage change in Excel, use the formula: ((new value - old value) / old value) 100.

What is the difference between a percentage increase and a percentage decrease?

A percentage increase refers to an increase in value, while a percentage decrease refers to a decrease in value. To calculate a percentage increase or decrease, use the formulas above.

How do I avoid common mistakes when calculating percentages in Excel?

To avoid common mistakes when calculating percentages in Excel, double-check your formulas, use the correct formulas, and format your cells correctly.