Friday, March 16, 2012

How to Calculate Percents in Excel 2003


1. Determine the part and whole of the percentage you want to calculate. For example, assume a student receives 37 out of 75 points on a test.
2. Type the smaller number in cell A1. In the example above, you would type '37' in A1.
3. Type the larger number in cell A2. In the example above, you would type '75' in A2.
4. Type '=A1/A2' in cell A3. This is your percentage in decimal form. In this example, you will see 0.4933. Keep your cursor on this cell.
5. Press the '%' on the top of the window to convert the decimal to percentage. In the example, '0.4933' will change to '49.33%.'

Blogger news