M
MontyCR
I built a spreadsheet to calculate an output variable based on about a dozen
different input variables. I want to make an array that shows values for that
output variable as two of those variables are swept through a wide range of
values and the rest are kept constant. The calculations are broken up into
too many levels and subsections for me to be comfortable expressing the
output variable purely as a function of the input variables (right now it's a
function of several functions of the input variables) so that rules out the
normal method for filling in an array. Is there any way I can do this now
other than going through every combination of input variables and manually
entering the output value into a table?
different input variables. I want to make an array that shows values for that
output variable as two of those variables are swept through a wide range of
values and the rest are kept constant. The calculations are broken up into
too many levels and subsections for me to be comfortable expressing the
output variable purely as a function of the input variables (right now it's a
function of several functions of the input variables) so that rules out the
normal method for filling in an array. Is there any way I can do this now
other than going through every combination of input variables and manually
entering the output value into a table?