if you’re calculating number grades in MSExcel/OOCalc, and you want to drop the lowest score, but only for one test/assignment, use this formula:
=(SUM(A1:A5)-MIN(A1:A5))/(COUNT(A1:A5)-1)
where “A1:A5” is the actual range.
this came up in the vanpool the other day, whether it could be done w/out a macro, and I just couldn’t let it go.? (sometimes my brain works that way)
let’s just say it was a severe nerd moment.