Calculation formula

I will provide details too for explanation.

Please see the problem formula in yellow. I am trying to add the four cells that are in orange. The formula (in yellow) score should be a grade score out of 10.

The formula (P41) needs to calculate the cells in orange in row 41.

The orange cells relate to the grading percentages in row 39.

Cell E41 should calculate as 60/60 (100% correct) and is worth 20% of the grade (The Final Grade is out of 10).
Thus, equals 2 of the Final Grade.

Cell J41 should calculate as 20/20 (100% correct) and is worth 60% of the grade (The Final Grade is out of 10). Thus, equals 6 of the Final Grade.

Cell N41 should calculate as 7/10 (70% correct) and is worth 10% of the grade (The Final Grade is out of 10). Thus, equals 0.7 of the Final Grade.

Cell O41 is a score of 80% and is worth 10% of the grade (The Final Grade is out of 10). Thus, equals 0.8 of the
Final Grade.

The Formula in P41 should come up with an answer of 9.5. That being 9.5 out of a top grade score of 10.

Thank you for your effort.

Try this:

=(E41/60*2)+(J41/20*6)+(N41/10*1)+(O41/10*10)

You are using the SUM function throughout the worksheet where it is not actually needed.

Originally Posted by farhangul

Cell E41 should calculate as 60/60 (100% correct) and is worth 20% of the grade (The Final Grade is out of 10). Thus, equals 2 of the Final Grade.
Cell J41 should calculate as 20/20 (100% correct) and is worth 60% of the grade (The Final Grade is out of 10). Thus, equals 6 of the Final Grade.
Cell N41 should calculate as 7/10 (70% correct) and is worth 10% of the grade (The Final Grade is out of 10). Thus, equals 0.7 of the Final Grade.
Cell O41 is a score of 80% and is worth 10% of the grade (The Final Grade is out of 10). Thus, equals 0.8 of the Final Grade.
The Formula in P41 should come up with an answer of 9.5. That being 9.5 out of a top grade score of 10.

First, if N41 (7) should be interpreted as 7 out of 10, that part of the formula in P41 should be N41/10 * 0.1. You wrote N41*0.1.

Second, the 60/60 = 1 * 0.2 = 0.2, not 2. Likewise, 20/20 = 1 * 0.6 - 0.6, not 6. 7/10 = 0.7 * 0.1 = 0.07, not 0.7. And 80% * 0.1 = 0.08, not 0.8.

So the total would be 0.95, not 9.5. And the max is 0.2+0.6+0.1+0.1 = 1, not 10.

Finally, your use of SUM is unnecessary and not useful.

If you want 9.5 out of 10, the formula in P41 should be (reordering some terms for clarity):

=10 * (0.2*E41/60 + 0.6*J41/20 + 0.1*N41/10 + 0.1*O41)

This is a completely separate issue, but just change the formatting of the cell to match what you want to see:

h.mm AM/PM

Start a new thread - it's a completely different issue. Thanks.