C
chayrun
I need a formula for excel that lets me subtract the two lowest scores from a
list of scores. For example - my list of scores is 2, 5, 10, 10, 10, 10, 10,
10, 9. I would like a formula that would subtract the 2 and 5. All I've
been able to do is subract one lowest or subtract the same lowest two times
(which is not what I want).
The scenario is: my students take quizzes all semester and get to drop their
two lowest scores at the end of the semester. They have about 20 scores;
therefore, a formula for this would be helpful.
I have microsoft office excel 2003.
Thank you
list of scores. For example - my list of scores is 2, 5, 10, 10, 10, 10, 10,
10, 9. I would like a formula that would subtract the 2 and 5. All I've
been able to do is subract one lowest or subtract the same lowest two times
(which is not what I want).
The scenario is: my students take quizzes all semester and get to drop their
two lowest scores at the end of the semester. They have about 20 scores;
therefore, a formula for this would be helpful.
I have microsoft office excel 2003.
Thank you