View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Melanie Melanie is offline
external usenet poster
 
Posts: 78
Default Formula to find average of the best 2 of 3 scores

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