Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scores of a Range Cells. Highest or lowest depending a parameter | Excel Worksheet Functions | |||
how do i remove 5 lowest scores? | Excel Discussion (Misc queries) | |||
How do I set up a formula to throw out the 2 lowest scores? | Excel Worksheet Functions | |||
how to pick the lowest 10 golf scores | Excel Programming | |||
Trying to sum a range and drop the lowest 2 scores | Excel Programming |