Scenario result display
 

I found my own answer. It is the Data Table
functionality. Thx anyway!


-----Original Message-----
Some one has sent me a spreadhseet in EXCEL 2002 with a
matrix of values depending upon two vairables that can
each take on multiple values. I want to create something
similar. Let's assume one variable has 3 values and the
other has 4. So we have a 3 by 4 matrix (not counting
the
potential vairable values that are shown at the top and
down the side) of possible results from the combinations
all shown together. I think I've figured out how to do
sceanrio analysis in EXCEL but neither of the two choices
(summary report or pivot table) seem to produce the
simple
exhibit that I see here. I notice that the eqaution
shown
in each cell of the 3 by 4 is identical and says {=TABLE
(Q7,Q6)} and Q7 and Q6 are where the mid-range, base
case,
values of the two variables are. I assume that I must
define some sort of group area to get mine to look this
way. Can anyone tell me how this is done, please?

Deana
.

Scenario result display
 

I don't know where you posted your question, but I don't think it was in
microsoft.public.excel.programming.

We are all thrilled you found the answer, however.

Regards,
Tom Ogilvy

Deana wrote in message
...
I found my own answer. It is the Data Table
functionality. Thx anyway!


-----Original Message-----
Some one has sent me a spreadhseet in EXCEL 2002 with a
matrix of values depending upon two vairables that can
each take on multiple values. I want to create something
similar. Let's assume one variable has 3 values and the
other has 4. So we have a 3 by 4 matrix (not counting
the
potential vairable values that are shown at the top and
down the side) of possible results from the combinations
all shown together. I think I've figured out how to do
sceanrio analysis in EXCEL but neither of the two choices
(summary report or pivot table) seem to produce the
simple
exhibit that I see here. I notice that the eqaution
shown
in each cell of the 3 by 4 is identical and says {=TABLE
(Q7,Q6)} and Q7 and Q6 are where the mid-range, base
case,
values of the two variables are. I assume that I must
define some sort of group area to get mine to look this
way. Can anyone tell me how this is done, please?

Deana
.