|
teacher-how to convert a total number in a roe to a letter
-- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
What are the conversion criteria here?
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Howard" wrote in message ... -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
ie if total is great than say 89 it will equal an A, or if greater than 83 it
will equal a B, or if greater than a 86 than it will equal a B+ -- Thanks Howard "Bob Phillips" wrote: What are the conversion criteria here? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Howard" wrote in message ... -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
Bob;
new at this, did you receive the response -- Thanks Howard "Bob Phillips" wrote: What are the conversion criteria here? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Howard" wrote in message ... -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
Setup a table then use VLOOKUP function
"Howard" wrote: -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
How-- did not see the option under the function tab
THANKS -- Thanks Howard "Teethless mama" wrote: Setup a table then use VLOOKUP function "Howard" wrote: -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
I need all the numbers and all the letter grades so we can come up with the
formula. "Howard" wrote: -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
Howard
With column of scores in A enter this in B1 and double-click to copy down. =LOOKUP(A1,{0,50,60,70,80},{"E","D","C","B","A"}) Adjust for score ranges or more letter grades like C+, B- etc. =LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"}) Adjust to suit. Gord Dibben MS Excel MVP On Fri, 29 Dec 2006 15:37:00 -0800, Howard wrote: ie if total is great than say 89 it will equal an A, or if greater than 83 it will equal a B, or if greater than a 86 than it will equal a B+ Gord Dibben MS Excel MVP |
teacher-how to convert a total number in a roe to a letter
Gord gave you a solution, all it needs is adjustment to your grades and
grade thresholds. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Howard" wrote in message ... How-- did not see the option under the function tab THANKS -- Thanks Howard "Teethless mama" wrote: Setup a table then use VLOOKUP function "Howard" wrote: -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
Thanks for responding. The previous respondant "Gord" has given me the
answer. Again thanks for the help. -- Thanks Howard "Teethless mama" wrote: I need all the numbers and all the letter grades so we can come up with the formula. "Howard" wrote: -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
Bob:
Thanks for the reply any way. -- Thanks Howard "Bob Phillips" wrote: Gord gave you a solution, all it needs is adjustment to your grades and grade thresholds. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Howard" wrote in message ... How-- did not see the option under the function tab THANKS -- Thanks Howard "Teethless mama" wrote: Setup a table then use VLOOKUP function "Howard" wrote: -- Thanks Howard |
teacher-how to convert a total number in a roe to a letter
Gord:
It worked out perfect. Thanks so much for the respose and help. "HAVE A HAPPY NEW YEAR" !! -- Thanks Howard "Gord Dibben" wrote: Howard With column of scores in A enter this in B1 and double-click to copy down. =LOOKUP(A1,{0,50,60,70,80},{"E","D","C","B","A"}) Adjust for score ranges or more letter grades like C+, B- etc. =LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"}) Adjust to suit. Gord Dibben MS Excel MVP On Fri, 29 Dec 2006 15:37:00 -0800, Howard wrote: ie if total is great than say 89 it will equal an A, or if greater than 83 it will equal a B, or if greater than a 86 than it will equal a B+ Gord Dibben MS Excel MVP |
teacher-how to convert a total number in a roe to a letter
Thanks for the feedback and Happy New Year to you and yours.
Gord On Sat, 30 Dec 2006 20:16:01 -0800, Howard wrote: Gord: It worked out perfect. Thanks so much for the respose and help. "HAVE A HAPPY NEW YEAR" !! |
| All times are GMT +1. The time now is 08:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com