I dont know which function will do my work

[elias tauscher]

I have a fairly elaborate worksheet that thru various decisio
mechanisms, determines the value of two variables (dependent)
depending on the value of another two variables (independent).

The independent variables I want to vary in predetermined steps in
range I will establish and for each of this values I want to have th
second independent variable also vary in predetermined steps in a rang
I will establish.

I want to obtain a result worksheet that will provide me for each pai
of values of the independent variables the values of the dependen
variables, putting each set of data in a different row.

Any suggestions

 

[Niek Otten]

You need the Data>Table command.
Look in HELP for details. Take your time: it's not dead-easy, but with some
patience and persistence you should manage.
Should you not be able to get what you require, post again with detailed
formulas and cell addresses.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel