Changing numbers/percentages to letter grades
 

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?

Changing numbers/percentages to letter grades
 

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


"Preston Steele" wrote:

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?

Changing numbers/percentages to letter grades
 

here you go try this

=IF(A6="","",IF(A689,"A",IF(AND(A6<90,A679),"B", IF(AND(A6<80,A669),"C",IF(AND(A6<70,A659),"D",IF (A6<60,"F",""))))))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Preston Steele" wrote:

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?

Changing numbers/percentages to letter grades
 

Would it be possible to include all number, like 0-59, 60-69 - Like
=LOOKUP(E16,{0 to 59,60 to 69,70 to 79,80 to 89,90 to
100},{"F","D","C","B","A"})? How would this formula be typed out?

"Elkar" wrote:

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


"Preston Steele" wrote:

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?

Changing numbers/percentages to letter grades
 

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.
"Preston Steele" <Preston wrote in message
...
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?

Changing numbers/percentages to letter grades
 

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Preston Steele" wrote in message
...
Would it be possible to include all number, like 0-59, 60-69 - Like
=LOOKUP(E16,{0 to 59,60 to 69,70 to 79,80 to 89,90 to
100},{"F","D","C","B","A"})? How would this formula be typed out?

"Elkar" wrote:

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


"Preston Steele" wrote:

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?

Changing numbers/percentages to letter grades
 

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

"Preston Steele" wrote:

Would it be possible to include all number, like 0-59, 60-69 - Like
=LOOKUP(E16,{0 to 59,60 to 69,70 to 79,80 to 89,90 to
100},{"F","D","C","B","A"})? How would this formula be typed out?

"Elkar" wrote:

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


"Preston Steele" wrote:

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?

Changing numbers/percentages to letter grades
 

Apologies Elkar,
I've just virtually duplicated your reply. It wasn't there when I posted
mine!,
Regards,
Alan.
"Alan" wrote in message
...
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.
"Preston Steele" <Preston wrote in
message ...
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?