plz help in to creat formula of excel
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
|