View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dale hollingsworth dale hollingsworth is offline
external usenet poster
 
Posts: 1
Default nested "IF" function in Excel 2007

How would I write a function that will count the number of tests taken and if it is 5 subtract the lowest score and then average the remaining 4? If only 4 tests then the lowest is not subtracted.

Thanks