Tuesday, October 23, 2012

How to Calculate Percentages in Excel 2007


1. Open Excel, and in cell A1 type the numerator. In cell B1 type the denominator. For example, for 75 percent, in A1 type '3' and in B1 type '4.'
2. Type '=a1/b1' in cell C1. In the example, C1 will result in 0.75.
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.

Blogger news