Exam Tracking And Prodicted Grade

[pmarten8]

Hi im trying to setup a excel shet to track my progress

Im tying to make it so if there is a Y in the Pass Cell its worth 7point Merit Cell worth 8 points and the distinction cell is worth 9 point

Then need to add all the point to gether to give me an estmated grade based on the overall score

Iv got this so far but not working U6="Y",7,0

Pass 210-229

Merit 230-249

Distinction 250-259

Distinction*260 and above

My Course Guide.xlsx

Im really stuck greatful for any help

[acerrhod]

Check the attachment.. i am not sure if this is the result you needed

[Pepe Le Mokko]

Does this get you started? to change values if needed

[Oliver Vistisen]

Hi Peter,

You need to clarify how you are designating the points. At the moment I cannot make out how the "Y" for a completed exam goes on to equate to a Pass, Merit or Distinction

Oliver