98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - Solver
microsoft-excel-training - Solver
Resolved · Low Priority · Version Standard
RE: Solver
Dear Tammy
Solver is one of the tools that you use to analyze What if situations!!
A typical example where you could use Solver would be when you currently have a 25 % overall profit but you want to set your profit to 35 % in the next year. You may want to find out how much your sales figure might have to be in order to achieve this target. Or you might want to find out how much cut you would have to make on Marketing in order to achieve this profit figure.
By using the Solver you tell Excel to provide you such changes in the Sales or/and Marketing in order to achieve this result.
Another benefit you have in solver compared to using Goal Seek feature is that you can Cap (set limits) to some variables. for example, you might want to say that my marketing costs shouldn't be less than
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Repeat actionThe F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again. |