Sometimes persons would use scenarios to try out various values, especially if you know the result you want from the formula but are not sure what input the formula needs to get that result. For ...
You’ll find three of them — Goal Seek, Scenario Manager, and Data Tables — under the Data tab, within the Forecast group, ...
If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...