How to Calculate Percentage in Excel? With Step by Step Examples

Percentages are widely used in financial analysis, sales reports, and data comparisons. Whether you need to calculate discounts, profit margins, tax rates, or grade percentages, Excel simplifies the process with built-in formulas. But how do you calculate percentage in Excel efficiently?

Excel allows you to perform various percentage-based calculations, such as percentage increase, decrease, total contribution, and proportion comparisons, using simple formulas like =A1/B1*100 or the percentage format option. By mastering these functions, you can save time, improve accuracy, and analyze data effectively.

In this guide, we’ll walk you through step-by-step examples to help you compute percentages in Excel effortlessly. Whether you're a student, business professional, or analyst, learning these formulas will boost your Excel skills. Let’s get started!

Boost your data skills—enroll in upGrad’s Master’s in Data Science from LJMU today! 

Calculate Percentage in Excel

Excel is a powerful tool that offers various formulas and functions to perform calculations and analyze data efficiently. One essential operation is learning how to calculate percentage in Excel, which is widely used in sales analysis, grade calculations, and financial reporting.

When calculating the percentage, the proportion expressed as a fraction of one hundred is used. To put this another way, first the numerator and the denominator are divided, and then the resulting number is multiplied by 100. Without multiplying by 100, the percentage calculation in Excel is = Numerator/Denominator. Press “Ctrl Shift %” or click “%” on the Home tab’s “number” group to change the result to a percentage. 

Enhance your data expertise—join upGrad’s PG Diploma in Data Science from IIIT Bangalore today!

How to Calculate the Percentage in Excel (Basic Method)

Using simple mathematical operations is the most straightforward way to calculate percentage in Excel. You can determine the percentage by dividing one number by another and then multiplying the result by 100. Excel also provides built-in percentage formatting to simplify the process, making calculations faster and more accurate.

Let’s look at a detailed illustration:

Example: Mr. Kumar took a 15-day vacation, spending 10 days in the USA and 5 days in his hometown. How many days did he spend in America?

To calculate a percentage in Excel, follow these simple steps:

• Enter the portion days in a cell. For example, in cell A1, enter the number of days spent in the USA (5).
• Enter the total days in a separate cell. For example, in cell B1, enter the total number of vacation days (15).
• In another cell, use the following formula: =A1/B1*100. This formula divides the portion days by the total days and multiplies the result by 100 to get the percentage.
• Press Enter to calculate the result.

For example:

• In cell C1, enter the formula =A1/B1*100 to calculate the percentage of days spent in the USA.
• In cell C1, the result will be 33.33%.

By following these steps, you can calculate percentages in Excel using basic mathematical operations.

Fundamentals to Calculate Percentage

Let’s first grasp the basic ideas behind Excel percentage calculations before moving on to the calculation process. Excel stores percentages as decimal values, with 1 representing 100%. For instance, 0.5 is equal to 50% and 1 is equal to 100%. You may perform percentage calculations and show the results in the format you want by utilizing straightforward formulas.

Marksheet Percentage formula in Excel:

The steps for inputting formulas in Excel to compute mark sheet percentage formula in Excel are as follows:

• Choose the cell that will hold the percentage result.
• Enter the formula either directly in the selected cell or the formula bar.
• Start the equation with the equals sign (=).
• Enter the division symbol (/), then the numerator (the amount you wish to represent as a percentage).
• After the division symbol, enter the denominator (the total or benchmark value).
• In order to convert a decimal value to a percentage, multiply the formula by 100.
• To calculate the outcome and display the percentage, press Enter.

For example, you would enter the following formula to determine the proportion of students out of a total of 30 who scored above 80:

=(Total Students / Students Over 80) * 100

Excel will compute the percentage and show the result in the chosen cell once you press the Enter key.

What is the easiest Excel formula for calculating percentages?

The simplest way to calculate percentage in Excel is by using basic arithmetic operators in a formula. A percentage is determined by dividing the numerator (part) by the denominator (total) and then multiplying the result by 100.

For example, in a survey, if 50 individuals are asked their view on a crucial topic, and among them, 20 are in favor and 30 are against, the percentage of those in favor of the opinion is computed as (20/50)*100=40. Excel has functions and algorithms for calculating percentages. There are numerous percentage calculation formulae, but it all relies on what you want to do.

Fundamentals to Calculate Percentage Step-by-Step Examples:

Entering Formulas in Excel:

To enter the percentage formula or any other formula in Excel, follow these steps:

• Select the cell where you want to display the result.
• Enter the equal sign (=) to begin the formula.
• Input the formula using cell references and mathematical operators. For example, =B2/A2*100.
• Press Enter to calculate the result.

Automatic Percentage Calculation in Excel

Excel has built-in functions and features that simplify percentage calculations. You can use these functions to compute percentages for various scenarios. Here are a few examples:

1. Attendance Percentage calculation in Excel

Applying the formula for Percentage will allow us to show you how to find percentage formula in excel of people who attended a meeting using Excel. Let’s imagine we have a sample data set. An illustration of this can be seen in the following example:

Open Excel and create a new worksheet.

Step 1: Setting Up the Right Parameters for the Data Set

Step 2: Applying percentage formula in excel.

• Click the E5 cell first.
• Then, write down the subsequent formula.
• =D5/C5*100
• Afterward, press ENTER.
• The first student’s attendance rate is displayed in the E5 cell.
• Drag the Fill Handle tool from cell E5 to cell E11 to calculate the attendance percentages for the remaining students.

Step 3: View the final result:

The attendance percentages will be shown for each student in the range of cells E5 to E11.

2. Calculate the Percentage of Variation in Excel

When you want to figure out how much two values change from one another in relation to the starting value, computing the percentage of variation is helpful. An illustration is given below:

Step 1: Open Excel.

Step 2: Enter the starting value, say 100, in cell A1.

Step 3: Enter the result, for instance, 150, in cell B1.

Step 4: Enter the expression “=((C2-D2)/D2)*100” in cell C1.

Step 5: To see the result, press Enter.

Step 6: Cell C1 in Excel will show the outcome of the calculation of the variation’s percentage. In the given scenario, the result will be 50, signifying a 50% rise from the starting value of 100 to the final value of 150.

3. Increase or Decrease a Number Using the Percentage

Excel makes it simple to add or subtract a specified percentage from a figure. For chores like applying discounts or figuring out tax amounts, this is quite helpful. An illustration is given below:

Step 1: Open Excel.

Step 2: Enter the starting value, say 200, in cell A1.

Step 3: Enter the percentage increase or decrease of cell B1, example 10%.

Step 4: To determine the increased value, insert the formula “=A1*(1 B1/100)” in cell C1.

Step 5: To see the result, press Enter.

Step 6: The increased value will be calculated by Excel and shown in cell C1. The outcome in this case will be 220, a 10% increase over the starting figure of 200.

You can slightly alter the formula if you wish to compute the decreased value. An illustration is given below:

Step 1: Open Excel.

Step 2: Enter the starting value, say 200, in cell A1.

Step 3: Enter the percentage decline, for instance 15%, in cell B1.

Step 4: To determine the lowered value, put the formula “=A1*(1-B1/100)” in cell C1.

Step 5: To see the result, press Enter.

Step 6: Cell C1 in Excel will contain the calculated lowered value. In this case, the outcome will be 170, a 15% reduction from the starting number of 200.

Conclusion

Knowing how to calculate percentage in Excel is a crucial skill for professionals across industries. Whether you're analyzing sales data, tracking financial growth, or managing budgets, Excel’s percentage formulas make calculations quick and efficient. By using functions like =A1/B1*100, percentage increase/decrease formulas, and formatting options, you can simplify complex data analysis with ease.

Excel’s built-in tools allow you to automate percentage calculations, reduce errors, and improve data accuracy. As you practice these techniques, you'll be able to handle real-world data scenarios more effectively, making informed decisions based on precise calculations.

Kickstart your data science career with upGrad’s Job-Linked Advanced Data Science Bootcamp! Enroll now and land your dream job.

Looking to enhance your skills? Popular Excel tutorials can help you master data management and boost your productivity!

Explore Popular Excel Tutorials