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.

Create a table in say M1:N4 of

0 NY
4 MM
4.8 FM
5.4 EX

and then use

=VLOOKUP(B11,$M$1:$N$4,2,TRUE)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Mudskipper" wrote in message
...
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.

=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.