formula

  • Thread starter Thread starter Mitesh Hirani
  • Start date Start date
M

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
 
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
 
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:D,2)
 
Back
Top