I am a teacher and our school is doing our annual assessment. I need a formula.
Let's say I have Column B with all the students grade level: grade 1 to 7
I want to entered their grade equivalent testing scores.
For example, if a grade 4 student gets less 3.9 or lower, the text value NY
will appear.
If a grade 4 student gets 4.0 to 4.7, the text value MM will appear.
If a grade 4 student gets 4.8 to 5.3, the text valuie FM will appear.
If a grade 4 student getts 5.3, then EX will appear.

So basically, for their grade level, if they fall below their grade level =
NY. If they are at grade level (0.0) to + 0.7, then MM. If they are + 0.8 to
1.3, then FM. If they are +1.3, then EX.

Thanks in advance.