Changing numbers/percentages to letter grades

P

Preston Steele

I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get a
cell that pulls from two other cells (50% for classroom, pulled from another
worksheet and 50% for lab, also pulled from another worksheet, totaled in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How do I
do this?
 
E

Elkar

You could use the LOOKUP function. Something like:

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

You can add more numbers/grades if you want to include + and - grades.

HTH,
Elkar
 
J

John Bundy

here you go try this

=IF(A6="","",IF(A6>89,"A",IF(AND(A6<90,A6>79),"B",IF(AND(A6<80,A6>69),"C",IF(AND(A6<70,A6>59),"D",IF(A6<60,"F",""))))))
 
A

Alan

Try the LOOKUP function,
=IF(A1<>0,LOOKUP(A1,{0,70,80,90},{"F","C","B","A"}),"")
You can add/alter the figures and grades to suit. If A1 is empty, this will
return "" which is text. If you need to perform further calculations with
the result, change "" to zero (0),
Regards,
Alan.
 
R

RagDyer

If you had tried the formula first, before asking additional questions, you
would have discovered that it *does* work exactly as you wish.
 
P

Preston Steele

I am fumbling my way through the whole spreadsheet. If someone is willing to
e-mail me at [email protected] and work with me on this, I would
appreciate it. I can e-mail the form (it's rather large) to show you what is
going on. Nothing is working for some reason. There are a lot of merged
cells - not sure if this is causing problems, but not getting any farther
with the project.

Thanks,
Preston S.
 
A

Alan

Apologies Elkar,
I've just virtually duplicated your reply. It wasn't there when I posted
mine!,
Regards,
Alan.
 
Top