3 Variable Data Table?

[Ahouriani]

Hey guys,

I was hoping anyone knew how to create a 3 variable data table? It would be incredibly helpful if excel could calculate all the outputs based on the ranges of 3 variables, rather than 2. If anyone can help, I would sincerely appreciate it.



Thank you!

[alansidman]

Give us an example of what you wish to do. There may be alternative solutions to your issue. There are a lot of very bright people here. Give them a chance to give you an answer. Your current request is to vague for a specific response.

[Ahouriani]

Than alan,

I'm working on a financial model which has 3 variables in it, and each variable has a range of possibilities for calculating an output. For example, assume output = X, and variables = A, B, and C, then the equation is designed as: A + B + C = X

Input A has 100 possibilities, ranging from 1-100
Input B has 50 possibilities, ranging from 1-50
Input C has 50 possibilities, ranging from 1-50

I want to create a similar thing to a data table where I can input the ranges, give it the equation, and have it compile all the possible outputs. Unfortunately, it's impossible to do this manually, so I was really hoping you guys could help.

Thank you

[alansidman]

Look at this link and see if this will work for you.

http://www.amttraining.com/technical...mber-2009.html

[Ahouriani]

Thank you alan,

I'll take a look. I really, really appreciate this.