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
news:63e6p159l0lsiencm8m7tok0iq5ctbb29r@4ax.com...
> 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
> <khushee.1zj0by_1133717400.775@excelforum-nospam.com> 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