Formula for determing average based on weighting

J

John Sullivan

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?
 
B

Biff

Hi!

Try this:

A1 = 84
A2 = 91
A3 = 85

B1 = 0.6
B2 = 0.3
B3 = 0.1

=SUMPRODUCT(A1:A3,B1:B3)

Biff
 
J

joeu2004

John Sullivan said:
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?
Click to expand...

If I interpret your facts correctly, the simplest formula might
be:

=84*60% + 91*30% + 85*10%
 
Top