Posted to microsoft.public.excel.programming
|
|
Scenario Analysis... simple
You are still over 2,000 combinations. I can not imagine that this is what
you wanted...
"Jim Thomlinson" wrote:
Sorry I misread your post... The combinations are far less than that. I'll
look at it again...
"Jim Thomlinson" wrote:
Are you sure you want to do this. There are about 20,000 permiutations and
combinations of 12 scores in 4 categories? Unless I have missunderstood your
question...
"Darin Kramer" wrote:
Howdie,
I have 12 total scores.
Each score is an A, B, C or D
(say in a1,b1,c1,d1)
I have a formulae which calculates Percentages of each, combines them,
and then gives an overall result (say in cell E1)
I want to see effects of scoring 12 A, and zero B,C,D and then 11A,
1B,zero C's etc
ANy ideas?
Thanks
D
*** Sent via Developersdex http://www.developersdex.com ***
|