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 is widely used in grade sheets, financial reports, business analytics, and sales data analysis. Excel allows you to apply this calculation dynamically across multiple cells, ensuring accuracy and efficiency. Let’s explore different ways to use percentage formulas in Excel.

Defining Percentages

A percentage is simply a ratio of a value to the total, multiplied by 100. Excel provides a built-in percentage format to simplify these calculations. For example, if you scored 80 out of 100 in an exam, the percentage is:

In Excel, you can enter the formula as:

=A1/B1

Then, apply percentage formatting to display the result as 80% instead of 0.8.

Converting Fractions

Fractions can be easily converted into percentages using Excel formulas. Suppose you have a fraction where A1 = 5 and B1 = 20, you can apply the following formula: 

After formatting the result as a percentage, Excel will automatically display 25% instead of 0.25.

Decimals to Percentages

Decimals can also be converted into percentages using Excel’s built-in percentage formatting. If you have a decimal value like 0.85, Excel will convert it to 85% when percentage formatting is applied. Alternatively, you can use:

This formula will multiply the decimal value by 100 to display it in percentage form.

Using Excel’s Percentage Format

Instead of manually multiplying by 100, Excel allows you to apply percentage formatting to any numerical cell:

1. Select the cell(s) containing the decimal or fraction.
2. Go to the ‘Home’ tab in Excel.
3. Click on the ‘Percentage Style’ (%) button.
4. Excel will instantly convert values into percentages.

This feature ensures accuracy and saves time while working with percentage-based data in large datasets.

Percentages Calculation in Excel: Step-by-Step Methods

Excel provides multiple methods to calculate percentages, ranging from simple division to more advanced formulas. Understanding different percentage formulas in Excel sheets allows users to perform various calculations efficiently, whether for financial reports, academic assessments, or business data analysis. With these techniques, you can easily compute discounts, profit margins, salary hikes, tax rates, and percentage changes without manual calculations.

In this section, we will explore different approaches to how to calculate percentage in Excel using formulas, built-in functions, and formatting tools.

Division Method

The division method is the most straightforward way to compute percentages in Excel. It involves dividing a part (numerator) by the total (denominator) and formatting the result as a percentage. This method is useful for calculating student grades, financial reports, and business profit margins.

Division Method Basic Formula

The basic formula to calculate percentage in Excel using the division method is:

Once you apply percentage formatting, Excel will automatically multiply the result by 100 and display it as a percentage.

Example:

Suppose a company generates ₹50,000 in total sales revenue, with a profit of ₹10,000. The profit percentage can be calculated using:

After formatting the result as a percentage, the output will be 20%, indicating that the company made a 20% profit on total revenue.

This method is widely used in business analytics, academic performance reports, and stock market analysis.

Excel Formulas for Percentage Calculations

Excel provides a variety of built-in formulas to help automate percentage calculations. These formulas make it easier to analyze sales growth, revenue fluctuations, and percentage-based comparisons. Whether you are calculating tax rates, commission percentages, or loan interest rates, Excel simplifies the process.

Essential Formulas

• Basic Percentage Formula:

Used for general percentage calculations:

=A1/B1

This formula is applicable in mark sheets, financial reports, and performance analysis, allowing users to calculate percentages effortlessly.

• Percentage Change Formula:

Used to calculate the increase or decrease in percentage over time:

=(A1−B1)/B1

Example:

If last month’s sales were ₹50,000 and this month’s sales are ₹60,000, you can determine the percentage increase as:

=(60000-50000)/50000

After applying percentage formatting, the result will be 20%, meaning sales increased by 20% compared to the previous month.

This formula is particularly useful for tracking market trends, inflation rates, and stock performance.

• Increase/Decrease Percentage Formula:

This formula helps increase or decrease a number by a specific percentage:

=A1∗(1+B1%)

Example:

If an employee’s current salary is ₹40,000, and they receive a 10% salary hike, the new salary will be calculated as:

=40000*(1+10%)

The result will be ₹44,000, showing the updated salary after the percentage increase.

Similarly, to apply a discount or price reduction, you can use the same formula with a negative percentage. If a product priced at ₹1,200 has a 15% discount, the formula will be:

=1200*(1-15%)

The result will be ₹1,020, which is the final price after the discount.

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 the percentage increase or decrease in a dataset over time. It is widely used in financial analysis, business performance tracking, stock market trends, and student marksheets to evaluate changes efficiently.

In Excel, percentage variation calculations allow users to analyze trends with ease. By using the right formulas, you can calculate percentage values in various fields, including education, finance, and business analytics.

Marksheet Percentage Formula in Excel

Student marksheets often require percentage calculations to assess academic performance. Instead of manually computing scores, Excel simplifies this process using formulas.

To calculate student percentages efficiently, use:

Example:

If a student scores 450 marks out of 600, the percentage is calculated as:

After applying the formula, the result is 75%, meaning the student secured 75% in their exams.

This method is commonly used in schools, colleges, and universities to evaluate students' overall academic performance. Additionally, percentage calculations in Excel help in ranking students, setting grade thresholds, and analyzing subject-wise performance trends.

How to Use Excel to Calculate Percentage Increase?

Percentage increase is used to track growth in values such as salary increments, revenue growth, stock price appreciation, and inflation rates. It provides a clear picture of performance improvements over time.

Formula for Percentage Increase

Example:

If an employee’s salary increases from ₹50,000 to ₹60,000, the percentage increase is calculated as:

The result is 20%, indicating the salary has increased by 20% compared to the previous amount.

This formula is essential in business and financial analysis, as it helps track revenue growth, profit margins, and sales trends. Companies rely on percentage increase calculations to evaluate performance, analyze investment returns, and make strategic financial decisions.

How to Use Excel to Calculate Percentage Decrease?

Percentage decrease is used to analyze reductions in values, such as cost-cutting, budget reductions, expense tracking, and declining stock prices. Understanding percentage decreases in Excel helps businesses and investors assess market risks and financial losses.
 

Formula for Percentage Decrease

Example:

If a stock price drops from ₹1,200 to ₹1,000, the percentage decrease is calculated as:

After applying the formula, the result is 16.67%, indicating that the stock has lost 16.67% of its value.

This calculation is crucial for investors, traders, and financial analysts to track market fluctuations, predict trends, and manage investment risks effectively.

By mastering these percentage formulas in Excel, users can efficiently analyze data trends, financial growth, business metrics, and academic scores. Whether calculating percentage increases in profits or tracking market declines, Excel provides a simple yet powerful solution for handling numerical data.

Advanced Percentage Calculation Techniques in Excel

For complex calculations, Excel offers advanced functions like IF, ROUND, and ABS, allowing users to automate percentage-based decisions, refine accuracy, and analyze percentage differences effectively. These techniques make Excel a powerful tool for financial analysis, business forecasting, and academic performance tracking.

How to Calculate Percentage in Excel Using IF Function?

The IF function in Excel is a logical formula that helps automate decision-making based on percentage comparisons. It is particularly useful in business analysis, financial forecasting, and performance evaluations where conditions determine actions.

Example:

This formula checks if A1 (new value) is greater than B1 (old value) and returns "Increase" if true or "Decrease" if false.

Use Cases:

• Sales Analysis: If sales in the current month are higher than the previous month, Excel automatically labels it as an increase; otherwise, it is a decrease.
• Stock Market Tracking: Determines whether a stock's closing price has increased or decreased compared to the previous day.
• Employee Performance Evaluation: Identifies whether an employee's productivity has improved or declined based on percentage growth.

By integrating IF with percentage calculations, you can create dynamic reports that categorize and analyze changes efficiently.

Percentage Formula in Excel Sheet

For accurate percentage calculations, combining ROUND and ABS functions ensures that percentage values are properly formatted and precise, which is critical in financial reporting, budgeting, and trend analysis.

Example:

This formula calculates the percentage change and rounds the result to two decimal places, ensuring greater accuracy in reports.

How It Works:

1. (A1 - B1) / B1 * 100 → Calculates the percentage difference between two values.
2. ROUND(..., 2) → Ensures the result is rounded to two decimal places for precision.

Use Cases:

• Financial Modeling: Ensures exact percentage values in budgeting and profit calculations.
• Performance Tracking: Used in business reports to monitor percentage growth or decline in revenue.
• Market Research: Helps in rounding off percentage changes in consumer trends and survey data.

By applying advanced Excel percentage formulas, users can refine their calculations, improve decision-making accuracy, and generate professional reports with ease.

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 using Excel’s built-in formulas and formatting options, you can perform calculations accurately, reducing manual effort and errors. These techniques are valuable for professionals handling financial reports, business metrics, and academic evaluations. 

With a solid grasp of percentage calculations, you can streamline data analysis and make more informed decisions, making Excel an essential tool in both professional and academic settings.
 

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