View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default Scenario Analysis... simple

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