How to Calculate Percentages in Excel

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. Type the total in an adjacent cell. In the example, the student would type 60 in cell B1.
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. Highlight the cell with the decimal, and click '%' button under the 'Home' tab to convert the decimal to a percentage.