software

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 gt;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 gt; 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)

quot;Mudskipperquot; gt; wrote in message
...
gt; I am a teacher and our school is doing our annual assessment. I need a
formula.
gt; Let's say I have Column B with all the students grade level: grade 1 to 7
gt; I want to entered their grade equivalent testing scores.
gt; For example, if a grade 4 student gets less 3.9 or lower, the text value
NY
gt; will appear.
gt; If a grade 4 student gets 4.0 to 4.7, the text value MM will appear.
gt; If a grade 4 student gets 4.8 to 5.3, the text valuie FM will appear.
gt; If a grade 4 student getts gt;5.3, then EX will appear.
gt;
gt; So basically, for their grade level, if they fall below their grade level
=
gt; NY. If they are at grade level (0.0) to 0.7, then MM. If they are 0.8
to
gt; 1.3, then FM. If they are gt; 1.3, then EX.
gt;
gt; Thanks in advance.
gt;
=IF(C5lt;B5,quot;NYquot;,IF(C5-B5lt;=0.7,quot;MMquot;,IF(C5-B5lt;=1.3,quot;FMquot;,quot;EXquot;)))
Regards,
Stefi?udskipper??ezt ?rta:

gt; I am a teacher and our school is doing our annual assessment. I need a formula.
gt; Let's say I have Column B with all the students grade level: grade 1 to 7
gt; I want to entered their grade equivalent testing scores.
gt; For example, if a grade 4 student gets less 3.9 or lower, the text value NY
gt; will appear.
gt; If a grade 4 student gets 4.0 to 4.7, the text value MM will appear.
gt; If a grade 4 student gets 4.8 to 5.3, the text valuie FM will appear.
gt; If a grade 4 student getts gt;5.3, then EX will appear.
gt;
gt; So basically, for their grade level, if they fall below their grade level =
gt; NY. If they are at grade level (0.0) to 0.7, then MM. If they are 0.8 to
gt; 1.3, then FM. If they are gt; 1.3, then EX.
gt;
gt; Thanks in advance.
gt;