How to Calculate Percentage in Excel?[With Examples]

In the field of Data Analytics, Microsoft Excel has enabled professionals to visualize and interact with data from a better perspective. M S Excel can offer multiple functionalities on the go. Watch this video and get to know more about the usage of percentage formula in excel.

How to Calculate Percentage in Excel (Basic Method)

  • 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.

Your Data Analytics Career is Around The Corner!

Data Analyst Master’s ProgramExplore Program
Your Data Analytics Career is Around The Corner!

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.

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.

Percentage-In-Excel-Method-1

Step 1:

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

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

Percentage-In-Excel-Method-1-image-3

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.

Percentage-In-Excel-Method-1-image-4

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)

Percentage-In-Excel-Method-5

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.

-Percentage-In-Excel-Method-1-image-1

Step 3:

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

-Percentage-In-Excel-Method-1-image-6

The Final Table looks like this:

Percentage-In-Excel-Method-1-image-20

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

Also Read: 7 Ways to Improve Microsoft Excel Skills

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 

Join The Ranks of Top-Notch Data Analysts!

Data Analyst Master’s ProgramExplore Program
Join The Ranks of Top-Notch Data Analysts!

Step 2:

In the next step, you will try to figure out the actual values using percentages. To understand in a better way, let us get into the next segment.

Calculate the new total by using the variation in Percentage

You always come across many offers on multiple products. Picture this, you bought a mobile phone for 27,000 rupees after you get 23% off on the actual price value of the phone. Now, the question is, what was the actual price of the phone?

So the actual price of the phone can be calculated as follows.

Discount Price * Percentage = Reduced Amount

Discount Price + Reduced Amount = Original Price

Take a quick look at this practical example using an Excel Sheet.

Let us include a couple of phones in the list with their discount percentage. 

You can convert the discount percentage column to the percentage type by selecting the percentage function in the Home Ribbon.

Step 3:

Now, calculate the discount amount by using the formula shown below.

=(A4*C4)

Percentage-In-Excel-Method-3-image-1

Next, sum the discount amount and price after discount to get the original price using the formula shown below.

=A4+D4

Percentage-In-Excel-Method-3-image-2

The final table will be as shown below.

Percentage-In-Excel-Method-3-image-3

Further, you will learn how to calculate the increment or decrement in a number based on the percentage values.

Take Your Data Scientist Skills to the Next Level

With the Data Scientist Master’s Program from IBMExplore Program
Take Your Data Scientist Skills to the Next Level

How to Increase or Decrease a number Using the Excel Percentage Formula

Let us assume that you are running a company, and you want to give a 15% hike to all your employees. 

Step 1:

Let us enter the hike percentage in a new column next to the salary column.

Now, apply the following formula to get the updated salary.

Updated Salary = Existing Salary * ( 1 + Percentage of Hike )

=E4*(1+F4)

Percentage-In-Excel-Method-4-image-1.

Step 2:

Now, this formula will work only for one row. To apply the same to all the rows, just drag the cell as shown below.

Percentage-In-Excel-Method-4-image-2

The last table will appear as follows.

-Percentage-In-Excel-Method-4-image-3

Step 3:

Similarly, if you need to calculate the decrement, you can make a minor modification to the formula as shown below.

Updated Salary = Existing Salary * ( 1 - Percentage of decrement)

With that, you have reached the end of this "One-Stop Solution to Calculate Percentage in Excel" tutorial.

Choose the Right Program

With our courses, you'll learn to analyze data, create insightful reports, and make data-driven decisions that can help drive business success. Whether you're a beginner or an experienced professional, these courses will help you take your skills to the next level. So why wait? Sign up for Simplilearn's Data Analytics course today and start building the career of your dreams!

Program NameData AnalystPost Graduate Program In Data Analytics

Data Analytics Bootcamp
GeoAll GeosAll GeosUS
UniversitySimplilearnPurdueCaltech
Course Duration11 Months8 Months6 Months
Coding Experience RequiredNoBasicNo
Skills You Will Learn10+ skills including Python, MySQL, Tableau, NumPy and more
Data Analytics, Statistical Analysis using Excel, Data Analysis Python and R, and more
Data Visualization with Tableau, Linear and Logistic Regression, Data Manipulation and more
Additional BenefitsApplied Learning via Capstone and 20+ industry-relevant Data Analytics projectsPurdue Alumni Association Membership
Free IIMJobs Pro-Membership of 6 months
Access to Integrated Practical Labs Caltech CTME Circle Membership
Cost$$$$$$$$$$
Explore ProgramExplore ProgramExplore Program

Become an Expert in Data Visualization

With Our Top-notch Tableau TrainingGet Started
Become an Expert in Data Visualization

Next Steps

"Page Setup in Excel" can be your next stop. You will learn how Microsoft Excel will enable you to customize your page before you present your information through your EXCEL Sheets.

Simplilearn's Data Analyst certification course offered by Simplilearn teaches you the basic concepts of data analysis and statistics to help data-driven decision-making. This training introduces you to Power BI and delves into the statistical concepts that will help you devise insights from available data to present your findings using executive-level dashboards.

If you have any questions about this article's topics, please feel free to leave them in the comments section below. Our expert team will answer all your queries for you at the earliest!

FAQs

1. What is the Excel formula for percentage?

To calculate a percentage in Excel, you can use the formula: "=number/total*100". Replace "number" with the specific value you want to calculate a percentage of and "total" with the overall value or sum. Multiply the result by 100 to get the percentage representation.

2. How do you calculate 20% in Excel?

To calculate 20% in Excel, you can use the formula: "=number*0.2". Replace "number" with the specific value you want to calculate 20% of. Multiplying the number by 0.2 will give you the result that represents 20% of the original value.

3. How to use Excel formulas?

  1. Select the cell where you want the result.
  2. Start the formula with an equal sign (=).
  3. Enter the formula, using cell references and operators (e.g., +, -, *, /) to perform calculations.
  4. Use functions like SUM, AVERAGE, IF, etc., for more complex calculations.
  5. Press Enter to see the result. Excel will automatically calculate the formula based on the referenced cells. You can copy and paste the formula to other cells as needed.

4. How do you calculate 25% in Excel?

To calculate 25% in Excel, you can use the formula: "=number*0.25". Replace "number" with the specific value you want to calculate 25% of. Multiplying the number by 0.25 will give you the result that represents 25% of the original value.

About the Author

Ravikiran A SRavikiran A S

Ravikiran A S works with Simplilearn as a Research Analyst. He an enthusiastic geek always in the hunt to learn the latest technologies. He is proficient with Java Programming Language, Big Data, and powerful Big Data Frameworks like Apache Hadoop and Apache Spark.

View More

Find Post Graduate Program in Business Analysis in these cities

Post Graduate Program in Business Analysis, Oxford
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, OPM3 and the PMI ATP seal are the registered marks of the Project Management Institute, Inc.