I am trying to work out school results on spreadsheet. 'Pass' and 'Fail' results are done. Now I have to work out how to spread grace marks. For example, if student A passed 3 papers out of 7 and failed other 4. Pass mark is 32. He got 27 on Paper I, 25 on paper II, 28 on Paper III and 30 on Paper IV. Student A needs 18 grace mark spread over, so he'll pass the exam. How do I make the spreadsheet do this? Thanks..
Bookmarks