View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Scenario Analysis... simple

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 ***