How to Calculate Percentage in Excel?

Calculating percentages in Excel is an essential skill for professionals, students, and businesses. Whether you need to determine discounts, track growth rates, or analyze data, knowing how to calculate percentages in Excel can make your work more efficient.

In this guide, we’ll explore different formulas, including percentage increase, decrease, and other variations, to help you master this fundamental skill.

Boost your data skills with these Top 15 Free Online Excel Courses in India. Whether you're a beginner or an advanced user, these courses will help you level up your Excel expertise.

How to Calculate Percentage in Excel?

Understanding how to calculate percentages in Excel is the foundation of working with numerical data. A percentage represents a part of a whole, typically expressed as a fraction of 100. 

Excel simplifies percentage calculations using built-in functions and formulas, making it easy to handle financial, academic, and business-related data.

Percentages: The Base Formula

To calculate a percentage in Excel, you must understand its basic formula. The general formula to calculate percentage in Excel is:

This formula works for marksheets, financial reports, and sales data. Let’s break it down further.

Defining Percentages

A percentage is simply a ratio of a number to 100. In Excel, percentages are formatted by multiplying a fraction by 100. For example, if you scored 80 out of 100 in an exam, the percentage is:

Converting Fractions

To convert a fraction to a percentage in Excel, divide the numerator by the denominator and format the result as a percentage. For example: 

=A1/B1 

If A1 = 5 and B1 = 20, the percentage would be = 5/20 = 25% after formatting the cell as a percentage.

Decimals to Percentages

Decimals can also be converted into percentages using percentage formatting in Excel. If you have 0.85 in a cell and apply percentage formatting, it will automatically become 85%. You can also use:

=A1×100

Percentages Calculation in Excel: Step-by-Step Methods

Excel provides multiple methods to calculate percentages, from basic division to advanced formulas. Understanding different percentage formulas in Excel sheets will help you calculate discounts, profit margins, and salary hikes efficiently.

Division Method

The division method is the simplest way to calculate percentages in Excel. It involves dividing the part by the whole and formatting the result as a percentage.

Division Method Basic Formula

Use the following formula:

= A1/B1 

For example, if a company earned ₹50,000 in sales revenue, with a profit of ₹10,000, the profit percentage is:

=10000 / 50000 = 20%

Excel Formulas for Percentage Calculations

Excel offers built-in formulas to simplify percentage calculations for various use cases. Here are some essential formulas:

Essential Formulas

• Basic Percentage Formula:

=A1/B1

(Used for general percentage calculations in Excel sheets.)

• Percentage Change Formula:

=(A1−B1)/B1

(Used to calculate increase or decrease in percentage.)

• Increase/Decrease Percentage Formula:

=A1∗(1+B1%)

(To increase a number by a specific percentage.)

Also Check: 60 Advanced Excel Formulas – A Must Know For All Professionals

How to Automatically Calculate Percentage in Excel?

Instead of manually applying formulas, Excel allows you to automatically calculate percentages using formatting options and built-in functions like PERCENTAGE, PRODUCT, and IF. 

These methods simplify percentage calculations and ensure consistency in large datasets, making Excel an essential tool for financial analysis, business management, and academic purposes.

Step 1: Formatting Cells as Percentages

Formatting cells as percentages makes it easier to display values correctly. Instead of decimals, Excel converts numbers into percentage values instantly, enhancing readability and data representation.

How to Apply Percentage Formatting?

1. Select the cells containing numeric data.
2. Right-click and choose Format Cells.
3. Select the Percentage option and set decimal places as needed.
4. Click OK to apply the formatting.

This ensures all values in the selected range are displayed as percentages rather than decimal numbers.

Step 2: Displaying Results Automatically

Excel can automate percentage calculations by applying formulas to an entire column, ensuring quick computations across multiple values without manually inputting formulas for each cell.

How to Apply Formulas Automatically?

1. Enter the percentage formula in the first row.
2. Press Enter and then drag down the formula using the fill handle.
3. Excel will auto-populate percentage results for the entire column.

Step 3: Applying Percentage Formatting to Columns and Rows

Formatting complete rows or columns as percentages ensures that all entered values are instantly converted into a percentage format, helping maintain consistency in reports and dashboards.

How to Format an Entire Column or Row?

1. Select the row or column.
2. Right-click and choose Format Cells.
3. Select Percentage and confirm changes.

Step 4: Using Functions for Efficiency: PERCENTAGE, PRODUCT, and Other Functions

Excel offers various functions like PRODUCT and PERCENTAGE to speed up calculations, especially when dealing with large datasets that require consistent percentage calculations.

Example Using PRODUCT Function

If you need to increase a value in cell A1 by 5%, use the formula:

This automatically adds 5% to the value in A1, making it useful for price adjustments, tax calculations, and salary increments.

Step 5: Using Autofill to Extend Calculations

Autofill saves time by applying a formula across multiple rows or columns without manual input, making it ideal for large datasets and repetitive calculations.

How to Use Autofill?

1. Enter the percentage formula in the first cell.
2. Click the small square at the bottom-right of the cell.
3. Drag down to extend the formula to additional rows.

Step 6: Combining Functions for Complex Calculations

For advanced calculations, Excel allows you to combine functions like IF, SUM, and PERCENTAGE to analyze trends and make data-driven decisions.

Example:

This formula determines whether a percentage has increased or decreased, making it useful for financial reports and performance tracking.

How to Calculate Percentage Variation in Excel?

Percentage variation measures percentage increase or decrease in a dataset. It is commonly used in financial analysis, business tracking, and student marksheets to evaluate changes over time.

Marksheet Percentage Formula in Excel

To calculate student percentages efficiently, use:

If a student scores 450 out of 600:

This formula is widely used in educational institutions to determine academic performance.

How to Use Excel to Calculate Percentage Increase?

Percentage increase is used to track growth in values, such as salary or revenue changes, making it essential for financial and business analytics.

Formula for Percentage Increase

If a salary increases from ₹50,000 to ₹60,000:

This formula helps businesses measure performance growth over time.

How to Use Excel to Calculate Percentage Decrease?

Percentage decrease helps analyze reductions in values like expenses, stock prices, or budget allocations.

Formula for Percentage Decrease

If a stock price drops from ₹1,200 to ₹1,000:

This calculation is crucial for investors and financial analysts tracking market trends.

Advanced Percentage Calculation Techniques in Excel

For complex calculations, Excel offers functions like IF, percentage formula in Excel sheets, and percentage difference calculations, making it a versatile tool for various applications.

How to Calculate Percentage in Excel Using IF Function?

The IF function helps automate percentage-based decisions by comparing values, making it useful in decision-making scenarios.

Example:

This formula checks if one value is greater than another and returns “Increase” or “Decrease,” simplifying data analysis.

Percentage Formula in Excel Sheet

Combining ROUND and ABS functions refines percentage calculations by ensuring precision and accuracy.

Example:

This rounds the percentage change to two decimal places, making it useful for financial modeling and reporting.

Learn the basics step by step with this Excel Tutorial for Beginners and master spreadsheets with ease. Start learning today!

Conclusion

Mastering how to calculate percentages in Excel enhances your data-handling skills. Whether you need to calculate percentage increase, decrease, or apply the marksheet percentage formula in Excel, these methods streamline your workflow. 

By utilizing built-in formulas, formatting options, and automation features, you can efficiently analyze and interpret data with accuracy, making Excel an indispensable tool for professionals and students alike.

Unlock the power of data with our popular Data Science courses, designed to make you proficient in analytics, machine learning, and big data!

Explore our Popular Data Science Courses

Elevate your career by learning essential Data Science skills such as statistical modeling, big data processing, predictive analytics, and SQL!

Top Data Science Skills to Learn

Stay informed and inspired with our popular Data Science articles, offering expert insights, trends, and practical tips for aspiring data professionals!

Read our popular Data Science Articles