=VLOOKUP(A1,{720,"A";600,"B"},2,FALSE)

just extend that range or put it into a worksheet range and use that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Russell Hampton" wrote in
message ...
I am trying to create a column that will convert a number score into a
letter
score based on a range. For instance, if the cell has 720 in it then I
want
an A to print in another cell. If the number is 600 then a C should print.
I
can get it to print using an IF statement so long as there is only one
option. Any ideas for multiple options? I tried VLOOKUP but that doesn't
work.