Hi Chris,

Look in HELP for the DataTable 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

"CMD" wrote in message ...
|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
|