#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
On 2nd worksheet, you always can use formulas to calculate summary results based on data you entered into 1st worksheet!
|
#3
|
||||
|
||||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Repeat Record a certain number of times | stacey_e | Mail Merge | 7 | 07-07-2023 01:27 AM |
How to change the formula to get this result .... | LearnerExcel | Excel Programming | 2 | 02-11-2018 08:26 PM |
IF Formula not returns result - Help | Haha88 | Excel | 6 | 02-11-2018 02:07 PM |
Logic formula to only count patient once, even though they are listed multiple times | Carol Salcido | Excel | 17 | 02-26-2014 03:57 PM |
avoid duplicete record and merge the record with the existed record | hemant.behere | Excel | 0 | 01-10-2012 02:53 AM |