excel formula problem

[khushee]

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
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 lo

 

[Bob Phillips]

You have a response in .misc, no need to multi-post.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Jeff]

50 =IF(A8<=52,1,IF(A8<=59,1.3,IF(A8<=67,2,IF(A8<=69,2.8,IF(A8<=75,3,IF(A8<=79,3.6,IF(A8<=100,4)))))))
53 =IF(A9<=52,1,IF(A9<=59,1.3,IF(A9<=67,2,IF(A9<=69,2.8,IF(A9<=75,3,IF(A9<=79,3.6,IF(A9<=100,4)))))))
60 =IF(A10<=52,1,IF(A10<=59,1.3,IF(A10<=67,2,IF(A10<=69,2.8,IF(A10<=75,3,IF(A10<=79,3.6,IF(A10<=100,4)))))))
68 =IF(A11<=52,1,IF(A11<=59,1.3,IF(A11<=67,2,IF(A11<=69,2.8,IF(A11<=75,3,IF(A11<=79,3.6,IF(A11<=100,4)))))))
70 =IF(A12<=52,1,IF(A12<=59,1.3,IF(A12<=67,2,IF(A12<=69,2.8,IF(A12<=75,3,IF(A12<=79,3.6,IF(A12<=100,4)))))))
76 =IF(A13<=52,1,IF(A13<=59,1.3,IF(A13<=67,2,IF(A13<=69,2.8,IF(A13<=75,3,IF(A13<=79,3.6,IF(A13<=100,4)))))))
80 =IF(A14<=52,1,IF(A14<=59,1.3,IF(A14<=67,2,IF(A14<=69,2.8,IF(A14<=75,3,IF(A14<=79,3.6,IF(A14<=100,4)))))))
84 =IF(A15<=52,1,IF(A15<=59,1.3,IF(A15<=67,2,IF(A15<=69,2.8,IF(A15<=75,3,IF(A15<=79,3.6,IF(A15<=100,4)))))))
89 =IF(A16<=52,1,IF(A16<=59,1.3,IF(A16<=67,2,IF(A16<=69,2.8,IF(A16<=75,3,IF(A16<=79,3.6,IF(A16<=100,4)))))))
90 =IF(A17<=52,1,IF(A17<=59,1.3,IF(A17<=67,2,IF(A17<=69,2.8,IF(A17<=75,3,IF(A17<=79,3.6,IF(A17<=100,4)))))))
98 =IF(A18<=52,1,IF(A18<=59,1.3,IF(A18<=67,2,IF(A18<=69,2.8,IF(A18<=75,3,IF(A18<=79,3.6,IF(A18<=100,4)))))))
100 =IF(A19<=52,1,IF(A19<=59,1.3,IF(A19<=67,2,IF(A19<=69,2.8,IF(A19<=75,3,IF(A19<=79,3.6,IF(A19<=100,4)))))))

I did the formula's for you for each number on your chart. A8=50, A9=53,
A10=60, etc.

The formula's are all the same, and just apply it to each cell.

Good luck.

Jeff