I'm using the below table for as a lookup. This works fine.
My question is I would like a column that tells the pupil how many points from the next grade? For example a pupils scores 1341 which equals a MPP grade. They are 38 points from a MMP grade. How do I do this in a formula?