And to add to your nice idea Gord, we can make it a single array constant,
instead of 2.<g

=LOOKUP(A1,{1,53,60,68,70,76,80;1,1.3,2,2.8,3,3.6, 4})

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca@ wrote in message
...
Without using a table for the lookup values.

=LOOKUP(A1,{1,53,60,68,70,76,80},{1,1.3,2,2.8,3,3. 6,4})


Gord Dibben Excel MVP

On Sun, 4 Dec 2005 11:25:39 -0600, khushee
wrote:


hello to all
i want to discuss my problem with you related to MS excel.

i want to know or find out formula of excel which can help me in such a
way....

i want to make grade point of my college students in such a way..
for example....

marks grade point average

50 1
53 1.3
60 2
68 2.8
70 3
76 3.6
80 4
84 4
89 4
90 4
98 4
100 4

this is example

the student who get 50 marks the GPA will be 1
and who get 80 marks or above 80 the GPA should be 4

GPA should not less than 1 or grator than 4
please tell me the formula so that i can make this GPA

thanks a lot