Formulas

[Guest]

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

 

[Guest]

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.

 

[Guest]

=LOOKUP(A1,{0,70,90},{"B","P","A"})

A1=test score