HI friends,
I am calculating the point index of students, and do not want the result to exceed 10
Example
A student has accumulated total 163 grade points
He has registered for total of 16 credits
so his cpi = 163/16 = 10.19, but I do not want the result to exceed 10. Is there a way I can restrict these values to a maximum of 10?
I tried 'CEILING' function but no luck. I am sure there should be some function like ceiling for this issue. Please help me.
Best Regards
Last edited by Chandrajit; 12-06-2014 at 03:14 AM. Reason: solved
Best Regards
Chandrajit
If you don't want it to exceed 10 then try
=min(10,points/ credits)
Last edited by Crooza; 12-06-2014 at 03:02 AM.
Happy with my advice? Click on the * reputation button below
Superb Boss! it was that simple!
great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks