formula

[Mitesh Hirani]

hi, i am using microsoft excel 2007... i want to put a formula in a column a
follows...

i have data like if the index points are between 8-10 then the result column
should read A, 7-7.9 ======= B , 5-6.9=======C

score result
8 A
7.5 B
5.8 C
4.5 D


please tell me what formula i can use on the result column for it to come
automatic

 

[Jacob Skaria]

Try the below with your score in cell A1. Change the points to suit your
requirement...

=LOOKUP(A1,{0,4,5,7,8,10},{"","D","C","B","A",""})


If this post helps click Yes

 

[Sean Timmons]

Or, to make the data points easier to edit at a later time, just enter the
values and results below in columns

col C col D
0 F
4 D
5 C
7 B
8 A

=VLOOKUP(A1,C,2)