Results 1 to 2 of 2

Thread: Formula for averaging grades dropping lowest grade?

  1. #1

    Formula for averaging grades dropping lowest grade?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am setting up a grade book and would like to allow students to drop their lowest grade before averaging. How do I construct the formula?

  2. #2
    I found the formula that would work, but I thought I'd post it here in case someone else is looking for the same thing.
    Insert your own cell addresses and of course, the final number by which to divide, but this is the formula: =(SUM(B2:F2)-MIN(B2:F2))/4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •