Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating multiple scenarios
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating multiple scenarios
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement - multiple scenarios | Excel Worksheet Functions | |||
IF statement with multiple scenarios. | Excel Discussion (Misc queries) | |||
Summary table for multiple scenarios | Excel Discussion (Misc queries) | |||
How to do if/then formula with multiple scenarios. | Excel Discussion (Misc queries) | |||
Return multiple scenarios | Excel Worksheet Functions |