Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for determing average based on weighting
What is the formula for determining the following: If you have an 84 average
that counts as 60% of a grade (school); and you have 91 average that counts as 30% of a grade' and you have 85 average that counts as 10% of your grade, what is the formula to determine what your average of all 3 is, to arrive at a final grade point average? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for determing average based on weighting
Hi!
Try this: A1 = 84 A2 = 91 A3 = 85 B1 = 0.6 B2 = 0.3 B3 = 0.1 =SUMPRODUCT(A1:A3,B1:B3) Biff "John Sullivan" wrote in message ... What is the formula for determining the following: If you have an 84 average that counts as 60% of a grade (school); and you have 91 average that counts as 30% of a grade' and you have 85 average that counts as 10% of your grade, what is the formula to determine what your average of all 3 is, to arrive at a final grade point average? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for determing average based on weighting
"John Sullivan" wrote:
If you have an 84 average that counts as 60% of a grade (school); and you have 91 average that counts as 30% of a grade' and you have 85 average that counts as 10% of your grade, what is the formula to determine what your average of all 3 is, to arrive at a final grade point average? If I interpret your facts correctly, the simplest formula might be: =84*60% + 91*30% + 85*10% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula based on Len | Excel Discussion (Misc queries) | |||
caluculate an average based on 2 criteria | Excel Discussion (Misc queries) | |||
Average Formula with Criteria | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GradeBook | Excel Worksheet Functions |