From: fkistner on 7 Apr 2010 13:58 I have 8 categories that is being graded from 1-5 and each represents a different % value see my example: Category A = 15% Each individual can rate a question from 1-5 (5 being the best & carrying the whole 15%) I want to show where if you graded Question #1 a 5 = 15% versus if you graded it a 3 = X% -- I need to plug this type of formula into each of the categories Thanks! Category B = 10% Category C = 30% -- flojoe From: Simon Lloyd on 11 Apr 2010 04:11 In your category total you could use this and expand it as needed, i'm sure this can be done alot smarter: =CHOOSE(A1,0.03,0.05,0.07,0.1,0.15)+CHOOSE(A2,0.03,0.05,0.07,0.1,0.15)+CHOOSE(A3,0.03,0.05,0.07,0.1,0.15) f k i s t n e r ; 6 9 2 9 4 1 W r o t e : > I have 8 categories that is being graded from 1-5 and each represents a different % value see my example: Category A = 15% Each individual can rate a question from 1-5 (5 being the best & carrying the whole 15%) I want to show where if you graded Question #1 a 5 = 15% versus if you graded it a 3 = X% -- I need to plug this type of formula into each of the categories Thanks! Category B = 10% Category C = 30% -- flojoe -- Simon Lloyd Regards, Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=193728 http://www.thecodecage.com/forumz  |