Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Math functions in Excel | Excel Discussion (Misc queries) | |||
Help with worksheet and math functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
How can I add math functions to a comment? | Excel Worksheet Functions | |||
math symbols functions | New Users to Excel |