how to drop grades

E

excelguy

This is what I have so far:
column E is for Quizzes and column I is for Labs.
Quizzes (col E) counts for 10%.
Labs (col I) counts for 20%.

I want to drop the lowest 4 grades out of all the labs and quizzes for each
student. For example, if the lowest 4 are all quizzes then no labs get
dropped.

Therefore to compute how much each grade is worth I need to divide the
percent by the number of undropped grades in each column.
MY QUESTION IS: how do you make this formula ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top