How to calculate percentages in excel 2007

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to calculate percentages in excel 2007
Calculate percentages in Excel 2007. (computer image by blaine stiger from

Percentages are the product when dividing two numbers and multiplying by 100 per cent. Microsoft Excel allows for easy math calculations and for formatting a number as a percentage. This is particularly useful when trying to make many calculations in a short amount of time or seeing how calculations fluctuate based on a change in variable.

Skill level:


  1. 1

    Open Excel, and in cell A1 type the numerator. In cell B1 type the denominator. For example, for 75 per cent, in A1 type "3" and in B1 type "4."

  2. 2

    Type "=a1/b1" in cell C1. In the example, C1 will result in 0.75.

  3. 3

    Right-click cell C1, then click "Format Cells." Under the "Number" tab, click on "Percentage." Choose how many decimal places you want to take the percentage to. Hit OK. The number is now formatted as 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.