On Wed, 20 Jan 2010 13:29:01 -0800, 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


If your calculated value is in cell A1, try this formula in the cell
wher you want your "grade":

=LOOKUP(A1,{0,0.26,0.51,1.01,1.51,2.01,3.01,4.01,5 .11},{"I","H","G","F","E","D","C","B","A"})

Change the values to get the correct limits between the different
grades.

Hope this helps / Lars-Åke