Formula to find average of the best 2 of 3 scores

[Guest]

Hello, I have a spreadsheet that has test scores in 3 columns . All 3 tests
are out of 10. I would like to create a formula that takes the average of
the best 2 or the 3 tests. How would I do that?

Thanks

 

[T. Valko]

Try this:

=AVERAGE(LARGE(A1:C1,{1,2}))

 

[Guest]

Here are a couple of ways:
Sums the range, subtracts the smallest value and then divides by two
(assumes there will always be three values)
=(SUM(C2:E2)-MIN(C2:E2))/2
Averages the highest and second highest values in the range (works even when
there are only two values)
=AVERAGE(MAX(C2:E2),LARGE(C2:E2,2))
These formulas are for grades entered in columns C, D, and E. Adjust as
needed.

 

[Pete_UK]

Assuming your scores are in columns C, D and E starting on row 2, try
this:

=(SUM(C2:E2)-MIN(C2:E2))/2

Copy down as required.

Hope this helps.

Pete