How to Calculate Percentage in Excel?

 

How to Calculate Percentages in Excel

• The formula =C2/B2 should be entered in cell D2 and copied to any number of rows you require.
• You can view the resulting decimal fractions as percentages by clicking the Percent Style button (Home tab > Number group).
• As explained in Percentage tips, you should add more decimal places if necessary.

Or,

The Excel formula for calculating percentages is (without multiplying by 100) Numerator/Denominator. You can convert the output to a percentage by pressing CTRL+SHIFT+%, or by clicking "%" under the "number" group on the Home tab.

How to Automatically Calculate Percentage in Excel

Percentage formula in excel: Percentages can be calculated using the formula =part/total. As an example, if you're trying to apply a discount, you would like to reduce a particular amount by 10%. The formula is: =Price*1-Discount %. (Consider the "1" as a substitute for 100%.)

The Excel Percentage  Formula is a mathematical operation that involves multiplying the fraction by a hundred. The word percent belongs to the Latin language, where it was called "Per-Cent."

For example, consider you are in school and you have six subjects in total. You are asked to write an exam for each subject, and every subject has 100 marks to score. The total marks for all the subjects included sums up to 600. 

Step 1:

Let us imagine you scored 475 out of 600. Now, calculate the average of your scores.

Step 2:

The average is calculated by dividing your score by the total number of marks and multiply the fraction by 100.

That is,

(475/600)*100 = 79.16

It is clear from the answer that you have an average score of 79.16. 

Similarly, there are various scenarios where you might have to calculate the percentage of the multiple parameters involved in your Excel Datasheet. A few frequently faced procedures are discussed below.

Excel is just the start. Ready to unlock tools like Python, SQL, and Power BI? Data Analytics Masters Program and supercharge your analytics career. 🎯

What is Automatic Percentage Calculation in Excel

While working on Microsoft Excel, there are a set of built-in features and functions to implement the mathematical operations. Percentage Calculator is one such function available in Excel.

Now, let us consider an option where you can calculate each student's total scores in the class and calculate the overall Percentage. View the following image, for better clarity.

Step 1:

For calculating the total number of marks of all students, apply the following formula.

=(F3+G3+H3+I3+J3+K3)

The formula above works for one student in row number 3. For implementing the same formula for all the rows, you can drag the cell as shown below.

Step 2:

Now, in the next stage, you will calculate the Percentage. The formula for calculating the Percentage is as follows.

Percentage = Marks Obtained / Total Marks

That is,

=(L3/M3)

You might wonder that the fraction is not multiplied by 100. This is because you will use the percentage option as shown in the image below.

Step 3:

To apply the same formula to all the cells, you can drag the cell to all rows, as shown below.

The Final Table looks like this:

Advancing, you will try the scenario of calculating the percentage variation in Excel.

How to Calculate Percentage of Variation in Excel

Step 1:

Now consider the example of fuel. Every day, there is a variation in fuel prices. Consider the fuel price for today is 97 rupees per liter, and yesterday, the same fuel price was 91 rupees per liter. There is a rise of 6 rupees per liter and a rise of 0.06% on the fuel price. 

Percentage of Variation = (New Price - Old Price) / Old Price