Sunday, November 18, 2012

How to Create Percentages in Microsoft Excel 2003


1. Write out your fraction. The numerator, or top number, will be the amount you want to determine as a percent of the total. The denominator, or bottom number, will be the total amount. For example, if you have 18 marbles, five red and 13 green, and you want to determine the percent of green marbles, then 13 is the numerator and 18 the denominator.
2. Type the numerator in cell A1 of your Excel spreadsheet. Type the denominator in cell B1. Using our example, you would type 13 in cell A1 and 18 in cell B1.
3. Type the following equation in cell C1 to get a percentage from your equation:=(A1/B1)*100

Blogger news