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?

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?

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%