Use the =VLOOKUP() function
--
Gary''s Student - gsnu200909


"Reno" wrote:

want to assign a letter or number based on calculated value (much like a
grading scale.) If calc value is:
.0 to .25= I
.26 to .50= H
.
.
.
final one 5.1 =A

can you do as an array beside doing the If and < formula
thx