calculating multiple scenarios

  • Thread starter Thread starter CMD
  • Start date Start date
C

CMD

I have several variables to an equation. Each variable has multiple (but
finite possibilities). Is there a way that I can calculate the answer to the
equation looking at all possible combinations?
For example, let's say I am calculating the price of a car and there is an
input for the price of tires and an input for the cost of interior. Let's say
that each parameter has 2 options. I can get regular tires or sport tires and
for the other variable I can choose leather interior or cloth interior. So
there are 4 possible outcomes: reg tires/cloth, reg tires/leather, etc. Is
there a way...other than manually calculating each scenario...that I could
easily calculate the price for each of the 4 scenarios? Is there a way I can
say here is my equation and here are my variables and here are the potential
values for those variables an then have it kick out some sort of matrix
output? Thanks.
Chris
 
Hi Chris,

Look in HELP for the Data>Table command.
Takes a while to set up, requires it do be done accurately, but works great.

Post back in this thread if you have difficulties.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have several variables to an equation. Each variable has multiple (but
| finite possibilities). Is there a way that I can calculate the answer to the
| equation looking at all possible combinations?
| For example, let's say I am calculating the price of a car and there is an
| input for the price of tires and an input for the cost of interior. Let's say
| that each parameter has 2 options. I can get regular tires or sport tires and
| for the other variable I can choose leather interior or cloth interior. So
| there are 4 possible outcomes: reg tires/cloth, reg tires/leather, etc. Is
| there a way...other than manually calculating each scenario...that I could
| easily calculate the price for each of the 4 scenarios? Is there a way I can
| say here is my equation and here are my variables and here are the potential
| values for those variables an then have it kick out some sort of matrix
| output? Thanks.
| Chris
|
 
Back
Top