I teach a math class and when I give 8 quizzes, I drop the two or three lowest grades for each student. How can I accomplish this in Libreoffice Spreadsheet?
It depends how you need your data next. But let’s assume you want just a sum of the points minus 2 lowest:
=SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2)
or maybe you need the average:
=(SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2))/(COUNT(A1:A9)-2)
Or you might find =QUARTILE(A1:A9;1)
an interesting function