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


--
khushee
------------------------------------------------------------------------
khushee's Profile: http://www.excelforum.com/member.php...o&userid=29349
View this thread: http://www.excelforum.com/showthread...hreadid=490572