Introduction
Whether you’re a student and you want to calculate the percentage of marks or a professional analyzing sales figures, knowing how to calculate percentage in Excel is a very usefull skill to achieve this fast and effectively with automatic process. In this step-by-step guide, we’ll explain the process of calculating percentage in excel, with some real-life example to make it easy for everyone. Lets get started the journey of “How to calculate percentage in excel”
👉Related:- Download All The important excel formulas in a single file.
Step-1: Set Up Data InYour Excel Sheet.
Open your Excel sheet and organize your data as shown in the below table.
Now let’s take a look at the scenrio where we want to find the percentage of each student’s score out of the total marks.
Step 2: Understand the Percentage Formula
The basic formula for calculating a percentage in Excel is very simple. Percentage= (Part ÷ Whole)×100
Part Means:- The specific value or quantity that you want to express as a percentage of the whole.
Whole Means:- The entire or total quantity, from which the “Part” is derived.
To understand the part and whole in a better way look into the given examples…
Example-1: Student’s Exam Score
Let say a student got 70 out of 100 in this case, you want to calculate the percentage of the score he got.
- Part:- The score the student got, which is 70.
- Whole:- The total possible score, which is 100.
Example-2: Mango Price Increase
Let say yesterday Mango price was 100 Rs and today it is 150 Rs , in this case if you want to calculate the percentage of price increased.
- Part:- The increase in price, which is (150−100)=50 Rs.
- Whole:- The original price, which is 100 Rs.
You May Like:- The Effective Executive Book Summary
Step 3: Apply the Formula in the excel sheet
In column D (Percentage), next to the Total Marks of 1st Student (cell D2), enter the following formula and hit enter:
=(B2/C2)
‘In the excel formula we dont have to multiply it by 100, excel will automaticaly calculate this.’
This formula divides the student’s score (ie: Part) by the total marks (ie: Whole) to get the percentage, but it is not showing the result in percentage and only showing the result for the 1st student, To do as per the requirment follow the next steps.
Another way to calculate percentage in excel :- Know the formula for percentage of total in excel
Step 4: Drag down the Formula
Click on the small square at the bottom right corner of cell D2 (where you entered the formula), and drag it down to apply the formula to the remaining cells in column D. Excel will automatically adjust the cell references for each student.
Now the result is showing for the all students but not in percentage value, to achive that folow the next step.
Step 5: Format the Cells
Format the cells in column D to display the results as percentages. Select all the cells where percentage values will display(D2 to D4), Right-click on the cells, click “Format Cells,”
From the format cells dilog box choose the category “percentage” format then click ok.
You May Like:- What is financial risk management: The Significance of Risk Management in Finance
Done: Percentage calculated in Excel
Now You’ve successfully calculated percentages in Excel. Whether it’s grades, sales, or any other data, this method helps you understand the proportion of one value to the whole.
Now you can confidently use Excel to tackle percentage calculations for various scenarios. Excel isn’t just for numbers; it’s a tool that empowers everyone to make sense of data effortlessly.
You May Like:-The Power of Positive Thinking Summary: leads to success and a happier, more fulfilling life
