Ignore lowest of 5 numbers

[scrutherford31]

Hi guys, i'm new.

I have to create a spreadsheet for a class that calculates student grades.

In total there are 5 assignments, 1 midterm (worth 25% of final grade) and 1 final (worth 50% of final grade).

"The final grade should be calculated using the following information. The worst of the 5 assignments will be dropped. The assignments together make up 25% of the final mark."

That is the instruction. How do i create a formula to only keep the 4 best grades?

Here is the formula i had for calculating the grade using all the assignments:
=((SUM(B4:F4)/125*0.25)+(G4/50*0.25)+(H4/100*0.5))*100

 

[Astrett]

Does your assignment let you use the SMALL function?

 

[Astrett]

Because I was thinking you could do your AVERAGE formula, but then have it subtract out the smallest number before the average calculation by typing in something like, -SMALL(array, 1). "array" would be where the grades are stored and "1" would indicate that only the smallest number should be dropped.

Would that work?

 

[tusharm]

If I understand you correctly, SUM(B4:F4)/125 should be (SUM(B4:F4)-MIN(B4:F4))/100

Hi guys, i'm new.

I have to create a spreadsheet for a class that calculates student grades.

In total there are 5 assignments, 1 midterm (worth 25% of final grade) and 1 final (worth 50% of final grade).

"The final grade should be calculated using the following information. The worst of the 5 assignments will be dropped. The assignments together make up 25% of the final mark."

That is the instruction. How do i create a formula to only keep the 4 best grades?

Here is the formula i had for calculating the grade using all the assignments:
=((SUM(B4:F4)/125*0.25)+(G4/50*0.25)+(H4/100*0.5))*100

 

[scrutherford31]

That worked perfect. Thanks a bunch!!

Because I was thinking you could do your AVERAGE formula, but then have it subtract out the smallest number before the average calculation by typing in something like, -SMALL(array, 1). "array" would be where the grades are stored and "1" would indicate that only the smallest number should be dropped.

Would that work?