ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to drop grades (https://www.excelbanter.com/excel-discussion-misc-queries/250004-how-drop-grades.html)

excelguy[_2_]

how to drop grades
 
This is what I have so far:
column E is for Quizzes and column I is for Labs.
Quizzes (col E) counts for 10%.
Labs (col I) counts for 20%.

I want to drop the lowest 4 grades out of all the labs and quizzes for each
student. For example, if the lowest 4 are all quizzes then no labs get
dropped.

Therefore to compute how much each grade is worth I need to divide the
percent by the number of undropped grades in each column.
MY QUESTION IS: how do you make this formula ?


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com