QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Calculate Percentage in MS Excel 2016?

By Neha T Leave a Comment

We know various methods to calculate the percentage. Even the excel provides us with several ways to calculate the percentage. Percentage is a value that is a proportion, in relation to the whole data.

We can calculate the percentage for certain marks in examination, or calculating % discount for various prices, the percentage change between two numbers and so on.

For calculating percentage first confirm that the cell you are working on is in a percentage format or the parameter you take for calculations has values in terms of percentage. Now, you can build a formula to calculate percentage in a cell with percentage format.

Although we have a wide usage of calculating the percentage. We will discuss some of them below:

  1. Percentage of a whole
  2. Percentage of a Number
  3. Increase & Decrease a Number by Percentage
  4. Percentage Change between Two Numbers

Steps to Calculate Percentage in Excel 2016:

Before discussing the example for calculating percentage let us see, how to format a cell into percentage?

Step 1: Select a cell that you want to format into a percentage. Right-click on it and select Format Cells among the options.

Format of Cell 1

Step 2: A Format Cells dialog box will appear. Here, in Category select Percentage and in Decimal places select up to how many places you want to see numbers after the decimal. Click OK.

Format of Cell 2

Or

Step 1: You can directly change the format of a cell into Percentage by selecting Percentage, in the drop-down box of Number group of Home tab.

Format of Cell

Done you have formatted the cell to show data in percentage.


Percentage of a Total

The best example of this scenario would be calculating the percentage for a test.

See the image below, in a cell C2 we total number of marks for which the test was conducted. In cell B1 we have the number scored in the test by Stieve.

Percentage of Whole 1

Now, to calculate the percentage of marks, obtain by Stieve in the test, we have to type the formula.

=B21/C1    (confirm that the cell having formula is in a percentage format)

Percentage of Whole 2

Press Enter to obtain the result.

Percentage of Whole 3


Percentage of a Number

Here, we can use the example of calculating the amount, for certain discount on the original price.

In the cell B2, we have the original price for the shirt and in the C2 we have the discount offered on the original price in terms of percentage.

Percentage of a number 1

Now, we have to calculate the amount that will be reduced from the original price after applying a discount. So in cell D2, I have typed a formula:

=B1*C1

The original price of shirt $80 would be reduced by the $12. Now, the customer has to pay $68.

Note: Here, the discount value is with the % sign which automatically takes the value 15 % as 0.15. Here, we have taken the values in percentage so, we do not need to format the cell with formula into Percentage.


Increase & Decrease a Number by Percentage

We come across this scenario when we get a hike in our salary. Say it announced that your salary has been increased by 10% then how would you calculate the amount of your new salary?

Say your current salary amount is SA, then the formula for the new salary amount would be:

=SA + SA * 10%

Or it can be written as:

= SA * ( 1 + 10% )

In the image below, cell B1 has the current salary of Stieve and cell C1 has increase in the percentage of salary.

So, to calculate the new salary of Stieve the formula will be:

= B1*(1+C1)

Increase a number by percentage

The new salary amount of Stieve is 880.

Now, let us study decrease the number by percentage. Consider that the price of a daily product item say sugar falls down by 3%. Then how would you calculate the decreased price of sugar?

The formula to calculate the new decreased price of sugar is:

Say the price of sugar is S:

= S – S * 3%

Or

= S * (1 – 3%)

In the image below you can see that in cell B1 we have the current price of the sugar and in cell C1 we have the % decrease in the price.

To calculate the new decreased price of sugar we apply the formula

=B1 *(1- C1)

Decrease a number by percentage

The new decreased price of sugar is 77.6.


Percentage change between two number

Now let us take the above example of an increase in salary of Stieve. Earlier, the salary of Stieve was $800 and the new salary of Stieve is $880. Now, we will check the percentage change in the salary of Stieve.

The general formula for evaluating the percentage change between two numbers is:

=(New Value – Old Value) / Old Value

So, the formula to evaluate the percentage change in the salary of Stieve is:

=(C1-B1)/B1         (Keep the formula in the cell, with Percentage format)

percentage change bewteen two number

That’s all about calculating the percentage in Excel. You can explore it more with different examples and formulas.

You Might Also Like:

How to convert text to number in Excel - Featured ImageHow to Convert Text to Number in MS Excel 2016? Hide Formula in Excel - feature imageHow to Hide Formula in Excel? how-to-break-links-in-ms-excel-2016-featured-imageHow to break Links in MS Excel 2016? Change Date Format featured imageHow to Change the Date Format in Excel? how-to-use-vlookup-in-ms-excel-2016-featured-imageHow to use VLOOKUP in MS Excel 2016? Calculate Age in Excel feature imageHow to Calculate Age in Excel? Calculate Average in Excel feature imageHow to Calculate Average in Excel? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016?

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Enable and Disable Firewall in Ubuntu
  • How to Change Registered Mobile Number in Gmail Account
  • How to Change Logon Screen in Windows 10?
  • How to Rotate Screen in Windows 7?
  • How to create a “Google Apps for Work” account

Copyright © 2023 · QueHow · Contact Us