Maybe...

Put your values for a, b, c, d in column A1, B2, C2, and D2. (Put headers in
row 1).

Put a formula that does that complex calculation in E1. Then drag the formula
down column E as far as you need.

Jetta1515 wrote:

I've created a complex calculator that returns the value of X based on
the input of a, b, c, and d. I would like to create a table with
multiple values for a, b, c, & d. and have excel return the value of X
for each set of input variables. How can this be acomplished? TIA.

--
Jetta1515
------------------------------------------------------------------------
Jetta1515's Profile: http://www.excelforum.com/member.php...o&userid=34982
View this thread: http://www.excelforum.com/showthread...hreadid=547207

--

Dave Peterson