grading
What I am trying to do is in put 3 different set of tests. Each on weighing
with a % of the total. How do i do a formula to calulate this: Exam 1 Exam 2 Final 100 93 79 99 90 74 63 51 43 the first weighs 15% the second 25% and the final at 50%. What should i do? Thank you |
grading
Your percentages don't add to 100%.
Ignoring that, insert a new row above your test headings. Above Exam 1 type 15%. then put 25% and 50% above the other 2. Assume that is in Row 1, and your data then starts in cell A3. In D3 use this formula: =sumproduct(A$1:C$1,A3:C3) and copy it down "miranda" wrote: What I am trying to do is in put 3 different set of tests. Each on weighing with a % of the total. How do i do a formula to calulate this: Exam 1 Exam 2 Final 100 93 79 99 90 74 63 51 43 the first weighs 15% the second 25% and the final at 50%. What should i do? Thank you |
grading
Thank you so much and you are right, it wasn't 50% it was 60%. You really
helped. Miranda "Duke Carey" wrote: Your percentages don't add to 100%. Ignoring that, insert a new row above your test headings. Above Exam 1 type 15%. then put 25% and 50% above the other 2. Assume that is in Row 1, and your data then starts in cell A3. In D3 use this formula: =sumproduct(A$1:C$1,A3:C3) and copy it down "miranda" wrote: What I am trying to do is in put 3 different set of tests. Each on weighing with a % of the total. How do i do a formula to calulate this: Exam 1 Exam 2 Final 100 93 79 99 90 74 63 51 43 the first weighs 15% the second 25% and the final at 50%. What should i do? Thank you |
All times are GMT +1. The time now is 03:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com