Getting a Percentage

Once I have added up the total points scored, and the total possible points, it’s time to divide these to get a final score.  The formula is simple here again.  All I need is:

=SUM(points/total)

I need to use the two numbers I’ve just calculated in the last step to determine the percentage.  So, I plug them in to get:

=SUM(C19/D19)

I hit enter and I get a score.  It is worth checking to make sure the score is formatted in the percentage format, or I’ll end up with a .80 in the box.  I also have to check my decimal points, or I end up with a 80.0000000000000 or something like that.

Now I use the formula again to calculate the percentage score for all the tests and I’m ready to calculate a final, weighted grade.

Next Step – Weighted Scores >

Advertisements