Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dropping the lowest grade formula (Excel 2002)

    New Question:

    I have another question about figuring out an average after dropping the lowest grade. My quizzes have been worth slightly different points but I want them all to be considered equal so instead of using the raw score, I'm using the percentage that was calculated based on each raw score. As a result, I want to calculate the average of each of five quiz percent grades, but they appear in every other column (with the raw scores in between). The example you gave below was for five consecutive columns, i.e. B3:F3. How would I write the formula for every other column, i.e. B3, D3, F3, H3, J3? I've tried a couple of different ways but I keep getting an error message.



    Original Question:

    1) Students have taken 5 quizzes and their lowest grade can be dropped. How can I have Excel automatically drop each student

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropping the lowest grade formula (Excel 2002)

    The Large function will not work if the values are not in consecutive cells. To do this, put the formulas =B3, =D3, =F3, =H3, =J3 into five consecutive cells. Then use that range in the Large function.
    Legare Coleman

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Dropping the lowest grade formula (Excel 2002)

    How about:
    <pre>=(SUM(B3,D3,F3,H3,J3)-MIN(B3,D3,F3,H3,J3))/4</pre>


    Steve

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropping the lowest grade formula (Excel 2002)

    That should work.
    Legare Coleman

Posting Permissions

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