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