How to Calculate Percentages in Excel

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Calculate Percentages in Excel
Microsoft Excel allows uses to eliminate mathematical errors when calculating percentages. (laptop image by Angie Lingnau from

Percentages are a fraction of a number based on 100 as the denominator. People use percentages for many reasons such as trade discounts, sales discounts, sales tax and shipping. A common example of the use of percentages is on test grades where students get their per cent right based on the number of correct answers to the number of incorrect answers. The basic formula for a percentage is amount divided by total. Microsoft Excel allows for quick, error-free calculation of percentages.

Skill level:

Other People Are Reading


  1. 1

    Type the amount in a cell. For example, a student received a score of 48 out of 60 on a test and wants to find his percentage. The student would type 48 in cell A1.

  2. 2

    Type the total in an adjacent cell. In the example, the student would type 60 in cell B1.

  3. 3

    Type "=amount cell/total cell" in an adjacent cell to the total cell. Replace amount cell and total cell with the cell addresses of the amount and total. In our example, the student would type, "=A1/B1" in cell C1. The total will display 0.8 in cell C1.

  4. 4

    Highlight the cell with the decimal, and click "%" button under the "Home" tab to convert the decimal to a percentage.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.