I have question regarding a formula for the marking sheet for my university module:
I want to compare my students’ final numerical grade (titled ‘total_grade_point’ field in image one) with a range in an adjacent conversion table. The second table contains a numerical range (image two), and I want to get the final string for my student’s grade.
Basically, if you follow the images, I want to contrast my students’ grade point with the ranges in the conversion table, and then yield the grade string (zero, low fail, etc.).
I hope this is somewhat clear.
Thank you all for your help!