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 Fotolia.com)

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:
Easy

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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