if you happen to be a teacher

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:


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.