Nested IFs in Excel

[Diggar]

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

 

[carrr]

Use VLOOKUP instead:

http://www.uno.edu/~ucc/howto/misc/editors/letters.htm

http://www.internet4classrooms.com/excel_grade.htm

 

[carrr]

One mroe...

http://www.utexas.edu/its/training/handouts/excelgrade/

 

[SkipVought]

Hi,

just 4 simple ifs...

=IF(A3<60,&quot;F&quot;,IF(A3<70,&quot;D&quot;,IF(A3<80,&quot;C&quot;,IF(A3<90,&quot;B&quot;,&quot;A&quot;))))

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Diggar]

WOW! Thanks everyone for the quick response. I did use the 4 simple IFs and it worked fine but I want to give the VLOOKUP a shot later.

Now I can take my grades with me this morning to class. The students will be very happy, (well some of them, anyway )

Thanks again.