75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
 

im sry im a new user i need to know how to take for instance

quizzes homework participation
finalwith quizzes at 72% hw at 100% participation at 58% and final at 73% at
make a formula where i can use quizzes as 40 % of the final mark at the rest
20% each to come up with one grade

75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
 

Look for "weighted average"

--
Don Guillett
SalesAid Software

"canuckking" wrote in message
...
im sry im a new user i need to know how to take for instance

quizzes homework participation
finalwith quizzes at 72% hw at 100% participation at 58% and final at 73%
at
make a formula where i can use quizzes as 40 % of the final mark at the
rest
20% each to come up with one grade

75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
 

canuckking wrote:
im sry im a new user i need to know how to take for instance
quizzes homework participation
finalwith quizzes at 72% hw at 100% participation at 58% and final at 73% at
make a formula where i can use quizzes as 40 % of the final mark at the rest
20% each to come up with one grade

I think you are saying: you got 72%, 100%, 58% and 73% on quizzes,
homework, participation and final respectively, and you want to know
your total score given that quizzes count for 40% of the total and the
other categories count for 20% each. The following is one way to
compute the answer:

=sumproduct({0.72, 1, 0.58, 0.73}, {0.4, 0.2, 0.2, 0.2})

Of course, you can replace the constant arrays with ranges, if the
values are stored in cells.

75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
 

Thank you so much. Your a saviour.