Try this:

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


--
Biff
Microsoft Excel MVP


"Melanie" wrote in message
...
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