i'm working on a grading system in excel. my boss gave me a transmutation table
but cannot get the computations on how it was done. so i've created a lookup for the table.
Please Login or Register to view this content.
the problem is I don't want to use the lookup table, else create a formula that will immediately compute for the transmuted grade.
attach is the sample workbook.
Last edited by vlady; 10-19-2011 at 10:14 PM.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Its kind of long but its all in one. HTH
Please Login or Register to view this content.
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
thanks that's it.
by the way have any idea where did those numbers came from
I came with this but have decimal points and not accurate.
= ((tempgrade*50) / 100) + 45) ---ceiling number is 95
thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks