branston
09-04-2022, 09:44 AM
Hi
I am trying to check if a candidates score is within three marks of the UPPER BOUNDARY of list of numbers. If it is I just need a simple YES (or colour code the cell)
For eg
Grade boundaries
A -B -C -D -E
9 35 56 99 134
So if a candidates score was 54 then a YES should appear as the candidate is 2 marks away from a C Grade. However if the candidates scored 11 marks I do not need a YES as I am only interested in the Upper Boundary only ie. if the candidate is within 3 marks of the Higher Grade (than the ones they actually achieved).
I hope that makes sense and can anyone help? I've attached my test file.
I am trying to check if a candidates score is within three marks of the UPPER BOUNDARY of list of numbers. If it is I just need a simple YES (or colour code the cell)
For eg
Grade boundaries
A -B -C -D -E
9 35 56 99 134
So if a candidates score was 54 then a YES should appear as the candidate is 2 marks away from a C Grade. However if the candidates scored 11 marks I do not need a YES as I am only interested in the Upper Boundary only ie. if the candidate is within 3 marks of the Higher Grade (than the ones they actually achieved).
I hope that makes sense and can anyone help? I've attached my test file.