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

[Bob Phillips]

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

--

HTH

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


"khushee" <[email protected]> wrote in
message news:[email protected]...
>
> 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=490577
>

[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


"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
>
>
> --
> khushee
> ------------------------------------------------------------------------
> khushee's Profile: http://www.excelforum.com/member.php...o&userid=29349
> View this thread: http://www.excelforum.com/showthread...hreadid=490577
>
>