Nested IFs

[Dig]

I have Excel 2K and am trying to creat a nested IF statement that
would change a number grade to a letter grade.

In other words if the student received a 70 as the grade I want a
formula to convert that to a C. I was thinking that nested IFs are the way
so that the same formula will work for all grades A,B, C, D, F.

So it needs to check the cell to the left for the numeric grade and
then convert.
The grades are from
<60 =F
60-69 =D
70-79 =C
80-89 =B
90-100 =A

Any help would be apprecitated.
Thanks

 

[Peo Sjoblom]

Assume your number is in A1 this will return the grades

=IF(A1="","",VLOOKUP(A1,{0,"F";60,"D";70,"C";80,"B";90,"A"},2))

 

[Don Guillett]

try this
=LOOKUP(F1,{50,60,70,80,90},{"F","D","C","B","A"})

 

[Peo Sjoblom]

It will fail for students with lower numbers than 50, change 50 to 0 and it
will work

=LOOKUP(F1,{0,60,70,80,90},{"F","D","C","B","A"})

 

[Don Guillett]

OP can just shoot them

It will fail for students with lower numbers than 50, change 50 to 0 and it
will work

=LOOKUP(F1,{0,60,70,80,90},{"F","D","C","B","A"})

--

Regards,

Peo Sjoblom

 

[Ron Rosenfeld]

I have Excel 2K and am trying to creat a nested IF statement that
would change a number grade to a letter grade.

In other words if the student received a 70 as the grade I want a
formula to convert that to a C. I was thinking that nested IFs are the way
so that the same formula will work for all grades A,B, C, D, F.

So it needs to check the cell to the left for the numeric grade and
then convert.
The grades are from
<60 =F
60-69 =D
70-79 =C
80-89 =B
90-100 =A

Any help would be apprecitated.
Thanks

=HLOOKUP(NumberGrade,{0,60,70,80,90;"F","D","C","B","A"},2)


--ron

 

[Dig]

Thanks everyone. I am going to give the ole colleg go and I am sure the
students will be happy (at lesat some of them)

Thanks