multiple math functions in one formula
 

I am working with students grades and want to weight the tests higher than
other work. If I was doing this manually what I would be doing is averaging a
range of test cells then I multiply the average by 4. Then I add the other
work which is another cell to the previous answer and divide the whole thing
by 5
example B8 is 80%, B9 is 90%, B10 is 95% The sum of these = 265
265 divived by 3 = 88.33% (or average of this range of cells) then I want to
take this 88.33% and multiply by 4 which gives me 353.33% Then I want to add
in the other work which is cell B11 which = 60%
353.33% + 60% = 413.33% then if I divide by 5 I should get 82.67%
How do I put that in a formula?

multiple math functions in one formula
 

Lori wrote:
I am working with students grades and want to weight the tests higher than
other work. If I was doing this manually what I would be doing is averaging a
range of test cells then I multiply the average by 4. Then I add the other
work which is another cell to the previous answer and divide the whole thing
by 5
example B8 is 80%, B9 is 90%, B10 is 95% The sum of these = 265
265 divived by 3 = 88.33% (or average of this range of cells) then I want to
take this 88.33% and multiply by 4 which gives me 353.33% Then I want to add
in the other work which is cell B11 which = 60%
353.33% + 60% = 413.33% then if I divide by 5 I should get 82.67%
How do I put that in a formula?


=((AVERAGE(B8:B10)*4)+B11)/5


edvwvw

--
Message posted via http://www.officekb.com