Goal seeker & Solver

Dear Richard

Goal Seeker and Solver are both know as What IF features that allow the management to make appropriate decisions.

A typical example of Goal Seek is if you were self employed and had taken a loan for a specific period at a specific annual rate of interest.

You would use the PMT function to calculate the monthly payments.

Once you have calculated the monthly payments and you predicted that for a set amount of period you can pay more or less than the calculated monthly payments you can use the goal seek to either calculate how much Loan you will be offered or how many months you can pay off the loan in.

If you need an example of goal seek please let me know by replying to this post and I should be able to attach it for you (both goal seek as well as solver!!)

Solver is also for analyzing What If situations!!


A typical example where you could use Solver would be when you currently have a 20 % overall profit but you want to set your profit to 30 % 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.

By using the Solver you tell Excel to provide you such changes in the Sales 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