I need to show a % of a number

[fkistner]

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%

 

[Simon Lloyd]

In your category total you could use this and expand it as needed, i'
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


I have 8 categories that is being graded from 1-5 and each represents
different % value see my example

Category A = 15
Each individual can rate a question from 1-5 (5 being the best
carryin
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 formul
int
each of the categorie

Thanks

Category B = 10

Category C = 30
-
flojoe


--
Simon Lloyd

Regards
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)