| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
teacher-how to convert a total number in a roe to a letter
-- Thanks Howard |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
teacher-how to convert a total number in a roe to a letter
Setup a table then use VLOOKUP function
"Howard" wrote: -- Thanks Howard |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" !! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert number into word in excel i.e. 100 to one hundred | Excel Worksheet Functions | |||
| Mileage Claim Formula | New Users to Excel | |||
| Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| How do I add row total when cell contains both number and letter . | Excel Discussion (Misc queries) | |||
Linear Mode
