Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 --------------- Jacob Skaria "Mitesh Hirani" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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) "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Mitesh Hirani" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|