Hi all,

I am working on an assignment in my textbookwith a grade book. I've
already figured out the test average of 3 tests using the SUM and MIN
functions. The test grades are in cells B4:E4. I had to drop the
lowest grade and compute the average of the remaining three, which I've
already done.
=SUM(B4:E4)-MIN(b4:E4))/3
There is a next part I am stuck on. Students are required to complete a
designated number of homework assignments(which is 12 and it is in cell
E19). Then receive a bonus or penalty for ever additional or deficient
home assignment. The bonus is added to the test average to determine
the semester average. The penalty for each assignment missing is 2 and
that info is in cell E20 and the bonus for each additional assignment
is 1 and that info is in cell E21. Cell H4 is the bonus or penalty and
I4 is the semester average.
I would be grateful for any help. Thanks!

Kahlan


--
Kahlan
------------------------------------------------------------------------
Kahlan's Profile: http://www.excelforum.com/member.php...o&userid=27983
View this thread: http://www.excelforum.com/showthread...hreadid=474923