E10. A formula for weighted totals

Professor Blank wants to use a spreadsheet to compute for each student a weighted total of four quiz grades, where the students highest grade is multiplied by four, the next highest grade by three, the next highest by two, and the lowest by one. He requests a formula that will calculate this weighted total using only addition, subtraction, multiplication by an integer, and the min and max functions. Find such a formula.

The problem is a little harder than it appears at first. For a solution, go here.