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

On Nov 16, 7:08 pm, Melanie wrote:
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