#1
|
|||
|
|||
Equation for weighting on grades?
What is the equation for weighting on grades? 60% is the tests, 30% homework, 10 participation. |
#2
|
||||
|
||||
Hi
Please post a sample sheet ( click Go advanced - Manage attachments) showing data and expected results. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
With Grade in B2:B4 and Weight in C2:C4 try:
=SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complex IF(AND statement to manipulate weighted grades - better way? | ddeaton | Excel | 11 | 07-11-2016 02:03 PM |
Counting Grades on Excel Spreadsheet | Lear2016 | Excel | 1 | 01-04-2016 12:58 PM |
Powerpoint Quiz/Test advanced - Getting Grades or Results from Questions in show | Pete1 | PowerPoint | 1 | 05-17-2014 05:54 AM |
Equation help | markg2 | Excel | 11 | 02-05-2014 10:50 AM |
Why copying a paragraph to an equation ends without equation format??? | Jamal NUMAN | Word | 2 | 04-24-2011 06:18 AM |