Record result of a formula multiple times
I have a Worksheet with in which you enter a number, and it gives you a result having performed several calculations to get to the result.
i would like to create a table on another worksheet, which summarizes the results for a range of inputs.
the only way I can think of doing this is manually enter the number into the worksheet, note the result, and then log it in the table on the second worksheet.
is there a function which I can use to automate this?
|