Record result of a formula multiple times

[maw444]

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?

[ArviLaanemets]

On 2nd worksheet, you always can use formulas to calculate summary results based on data you entered into 1st worksheet!

[p45cal]

You could try out Scenarios, it's under What-If Analysis in the Forecast section of the Data tab of the ribbon.
You can set up a number of scenarios:
2022-11-25_162038.png

then click on Summary and you have a choice of output:

2022-11-25_161836.png


It's not often used but it's not bad.
Attach a file so that we can demonstrate?