Rank Order/ Grade

[Rebeccaberry]

Hello,

 

I am hoping you can help me. I am trying to set up a marksheet where pupils are assigned a rank order according to an assessment grade. I then need to assign a grade according to their rank order:

 

 

•A* = rank 1-32

•A = rank 33-60

•B = rank 60-122

•C = rank 123-180

 

 

What formula should I use to achieve this? Would you use a Lookup table?

 

Thank you

[IRL]

Put your grade table somewhere across three columns.

 

 

Formula: =LOOKUP(B2, J$2:J$5,L$2:L$5)

[Rebeccaberry]

Thank you