View Single Post
 
Old 11-25-2022, 09:19 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 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