| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grade sheet
we created a spreadsheet for our kids grades, ie.
we show quiz 15%, homework 10% and tests 75%. how do we average and weight the grade (and show the formulae) if there were no homework grades. thanks, mark reisbord |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
grade sheet
try:
=sumproduct({quiz,hoemwork,tests},{0.1,0.15,0.75}) -- HTH Regards Sebation.G "mjreisbord" ... we created a spreadsheet for our kids grades, ie. we show quiz 15%, homework 10% and tests 75%. how do we average and weight the grade (and show the formulae) if there were no homework grades. thanks, mark reisbord |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
grade sheet
If you are saying that you have no homework results but you want to maintain
the same relative weighting between quiz and tests, just divide your original answer by 90%. -- David Biddulph "mjreisbord" wrote in message ... we created a spreadsheet for our kids grades, ie. we show quiz 15%, homework 10% and tests 75%. how do we average and weight the grade (and show the formulae) if there were no homework grades. thanks, mark reisbord |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best/Worst grade | Excel Worksheet Functions | |||
| when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
| when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
| Grade Percentage into letter grade | Excel Discussion (Misc queries) | |||
| i need need a grade sheet for average several assignments. | Excel Discussion (Misc queries) | |||
Linear Mode
