Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2022, 04:26 AM
maw444 maw444 is offline Record result of a formula multiple times Windows 10 Record result of a formula multiple times Office 2019
Advanced Beginner
Record result of a formula multiple times
 
Join Date: Feb 2021
Posts: 35
maw444 is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 11-25-2022, 05:59 AM
ArviLaanemets ArviLaanemets is offline Record result of a formula multiple times Windows 8 Record result of a formula multiple times Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

On 2nd worksheet, you always can use formulas to calculate summary results based on data you entered into 1st worksheet!
Reply With Quote
  #3  
Old 11-25-2022, 09:19 AM
p45cal's Avatar
p45cal p45cal is offline Record result of a formula multiple times Windows 10 Record result of a formula multiple times Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Record result of a formula multiple times Mail Merge Repeat Record a certain number of times stacey_e Mail Merge 7 07-07-2023 01:27 AM
Record result of a formula multiple times 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
Record result of a formula multiple times 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft