=IF(C5<B5,"NY",IF(C5-B5<=0.7,"MM",IF(C5-B5<=1.3,"FM","EX")))
Regards,
Stefi


€žMudskipper€� ezt Ã*rta:

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.