Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing numbers/percentages to letter grades
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a value to a letter | Excel Worksheet Functions | |||
Changing a letter, to a number??? | Excel Discussion (Misc queries) | |||
try to convert letter grades into GPA grade points | Excel Worksheet Functions | |||
Converting Letter Grades to Numeric | Excel Worksheet Functions | |||
Changing text from all caps to first letter cap | Excel Discussion (Misc queries) |