Changing numbers/percentages to letter grades

[Guest]

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?

 

[Guest]

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

 

[Guest]

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",""))))))

 

[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.

 

[RagDyer]

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

 

[Guest]

I am fumbling my way through the whole spreadsheet. If someone is willing to
e-mail me at (e-mail address removed) 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.

 

[Alan]

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