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