Programs

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

It’s simple to calculate percentages mathematically, and knowing how to do so is a skill that may be applied to both personal and professional situations. There are times when you might need to write a ratio or part of a number as a percentage of another number.

In this article, we’ll look at the fundamental formula for computing percentage formula in excel and go through step-by-step instructions of Fundamentals to computing percentage through Attendance percentage calculation, calculating the percentage of variables, increasing or decreasing a number using percentage. You can apply these skills and upgrade yourself by enrolling in a Master of Science in Data Science from LJMU.

Calculate Percentage in Excel

Excel is a strong program that provides a variety of formulae and functions to conduct calculations and analyze data. Calculating percentages is one calculation you might come upon. Knowing how to compute percentages in Excel can be quite helpful when working with sales figures, grades, or any other numerical data. 

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. In order to upskill your expertise in depth, head on to the Executive PG Programme in Data Science from IIIT Bangalore. 

How to Calculate the Percentage in Excel (Basic Method)

Using simple mathematical operations is the most direct method for calculating a percentage in Excel. We can calculate the percentage value by taking a number, dividing it by another number, then multiplying the result by 100. 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?

Using the fundamental arithmetic operators in an Excel formula is the simplest method for calculating percentages. A percentage can be calculated by taking the entire (denominator) and dividing it by the portion (numerator), 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.

Explore our Popular Data Science Courses

Conclusion

In summary, this article offers a thorough tutorial on how to compute percentages in Excel. It underscores the need of comprehending the fundamental concepts underlying percentage computations and the fundamental formula for computing percentages. The page provides step-by-step instructions for a variety of circumstances, including calculating attendance percentages, figuring out how much variance there is, and changing a figure by a %. Users can efficiently and effectively calculate percentages by adhering to the guidelines and using Excel’s functions and formulas. Excel is a useful tool for both professionals and academics because of its adaptability and mathematical capabilities. To boost your confidence as a Data Professional, you can opt for Graduate Certificate Programme in Data Science from upGrad. 

Can Excel handle simultaneous multi-percentage calculations in one time?

Yes, Excel allows you to perform several % calculations simultaneously by utilizing cell references and a range of cells to apply the percentage formula in excel.

Can Excel be used to determine the percentage difference between two values?

Yes, you can use the Excel formula ((new value - old value)/old value)*100 to determine the % change between two numbers.

Want to share this article?

Leave a comment

Your email address will not be published. Required fields are marked *

Leave a comment

Your email address will not be published. Required fields are marked *

×
Get Free career counselling from upGrad experts!
Book a session with an industry professional today!
No Thanks
Let's do it
Get Free career counselling from upGrad experts!
Book a Session with an industry professional today!
Let's do it
No Thanks