How to calculate percentage in excel: Microsoft Excel is a powerful tool for calculations, and one of the most common tasks people perform is calculating percentages. Whether you’re working on sales reports, student grades, or financial data, knowing how to calculate percentages in Excel can save time and effort.
In this blog, we’ll go through simple methods to calculate percentages in Excel with examples.
Table of Contents
1. Basic Percentage Formula in Excel
The percentage formula in Excel is: Percentage=(PartTotal)×100\text{Percentage} = \left( \frac{\text{Part}}{\text{Total}} \right) \times 100
However, Excel automatically formats numbers, so you don’t always need to multiply by 100.
Example:
Suppose you have the following data:
| Subject | Marks Obtained | Total Marks |
|---|---|---|
| Math | 80 | 100 |
| Science | 75 | 100 |
To calculate the percentage of marks obtained:
- Click on the cell where you want the percentage (e.g., C2).
- Enter the formula:
=B2/A2 - Press Enter and drag down the formula if you have multiple rows.
- Select the column and click Percentage (%) in the toolbar to format the result correctly.
2. Finding Percentage Increase or Decrease
To calculate the percentage increase or decrease, use: New Value−Old ValueOld Value×100\frac{\text{New Value} – \text{Old Value}}{\text{Old Value}} \times 100
Example:
If sales increased from 5000 to 7000, the formula would be:
=(7000-5000)/5000
After pressing Enter, format the result as a percentage.
3. Calculating Discount Percentage
To find the discount percentage given the original and discounted price: (Original Price−Discounted PriceOriginal Price)×100\left( \frac{\text{Original Price} – \text{Discounted Price}}{\text{Original Price}} \right) \times 100
Example:
If a product was ₹200 and is now ₹150, use:
=(200-150)/200
Then, format it as a percentage.
4. Final Thoughts
Excel makes percentage calculations easy with simple formulas. Just remember:
✔ Use =Part/Total for basic percentages
✔ Use =(New Value – Old Value)/Old Value for changes
✔ Format as Percentage (%) for proper display
Once you get the hang of it, calculating percentages in Excel will be a breeze! 🚀
Got any questions? Drop them in the comments! 😊