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