You're going about it backwards. Try:

=IF(D1>89,"A",IF(D1>79,"B",IF(D1>69,"C",IF(D1>59,"D","F"))))

By testing if D1>59 first, then 72 would be true as would 100!

If your grade is in cell A1, you could use

=VLOOKUP(A1,{0,"f";60,"d";70,"c";80,"b";90,"a"},2)

Erik,

Lets suppose this to be your conversion table:

{0,"F";

60,"D";

70,"C-";

75,"C";

77,"C+";

80,"B-";

85,"B";

87,"B+";

90,"A-";

94,"A";

98,"A+"}

You might post your real table if necessary.

Lets also suppose that you have a score in A1,

in A2 enter: =VLOKKUP(A1,{0,"F";60,"D";70,"C-";75,"C";77,"C+";80,"B-";85,"B";87,"B+";90,"A-";94,"A";98,"A+"},2,0)

It'll give what you want.

You can also have this table in some sheet, give it a name, and use that name in the above formula.

In order to that:

Select all of the cells of this table (don't include any labels in the selection);

Go the Name Box on the Formula Bar and type e.g., LETTERGRADES followed by ENTER.

Chan ge the above formula to:

=VLOKKUP(A1,LETTERGRADES,2,0)

Aladin

========

I can help you as im doing this for an A Level project

Im willing to help you but i have to ask are you

really just helping a teacher or is it for your

project - ill still help im just interested to know

who else is doing this project.

Heres what you do.

You have to create a named list of cells that

you can then lookup the percent score against and

have the result put in your grade cell.

Type the percent values in cells A1 to A6 (e.g. 69

for the C grade, 75 for the B, etc. in cells B1

to B6 enter the correspoding grades with the

lowest grade at the top going down. then select A1

to B6 and in the cell display box to the left of

the formula box type in "GradeBoundaries" (without the

quotes)and hit enter. Then check that this range

is named by picking GradeBoundaries from the drop-down box

It should select these cells.

Ok the next stage is to enter in the cell where

you want to display the formula the following:

=LOOKUP(V7,GradeBoundaries)

V7 is the cell where the percentage being looked

up agaist your list of grade boundaries is.

You can change it to the cell where your % is stored

If you need any more help just e-mail me (see above)

Hey that works great, thanks alot, I didnt think about going the other way....