Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
How do I write a formula that will assign letters to a range of number
values. For example, I have a range of test scores in a column. In the next column I want corresponding letters. 90 to 100=A; 70 to 89=P, 0 to 69=B. Thanks, Nordic |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
You can use the VLOOKUP function to do this.
For example, in cell E10, enter the following function... =IF(E8<"",VLOOKUP(E8/C8,$Q$7:$R$18,2),"") In this example, I created a range of values starting in Q7 and ending in R18. Column Q is my quality points (numeric values), and column R is my letter grades. Q7 = 0.0 R7 = F Q8 = .6667 R8 = D- etc. -- RichG "Nordic" wrote: How do I write a formula that will assign letters to a range of number values. For example, I have a range of test scores in a column. In the next column I want corresponding letters. 90 to 100=A; 70 to 89=P, 0 to 69=B. Thanks, Nordic |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
=LOOKUP(A1,{0,70,90},{"B","P","A"})
A1=test score "Nordic" wrote: How do I write a formula that will assign letters to a range of number values. For example, I have a range of test scores in a column. In the next column I want corresponding letters. 90 to 100=A; 70 to 89=P, 0 to 69=B. Thanks, Nordic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) | |||
"IF..THEN.."formulas | Excel Worksheet Functions |