Re: grade ***

From: "Sebation" <ec.wangqian@xxxxxxxxx>
Date: Tue, 18 Sep 2007 11:24:57 +0800

try:
=sumproduct({quiz,hoemwork,tests},{0.1,0.15,0.75})

--
HTH

Regards
Sebation.G
"mjreisbord" <mjreisbord@xxxxxxxxxxxxxxxxxxxxxxxxx> Ð´ÈëÏûÏ¢ÐÂÎÅ:7301E35A-278E-4EB6-A8A6-4E1600E1BBDB@xxxxxxxxxxxxxxxx

we created a spread*** 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

Prev by Date: Re: Can I create multiple formats of text in a formula?
Next by Date: Re: Drop Down List Help
Previous by thread: Re: Can I create multiple formats of text in a formula?
Next by thread: Re: grade ***
Index(es):
- Date
- Thread