Giving different text for different numbers

[Guest]

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.

 

[Bob Phillips]

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)

 

[Guest]

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


„Mudskipper†ezt írta: