O'Reilly logo

Office 2013 In Depth by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Goal Seek and Solver

As mentioned earlier in this chapter, Excel also provides two other analysis tools: Goal Seek and Solver. Goal Seek is designed to work backward from a desired outcome. Goal Seek determines that value that is required for a particular input cell to get a specific result in a dependent formula or function. Goal Seek is designed to help you determine the value of only one input cell involved in the calculation, so although it can be extremely useful, it is also fairly limited.

Solver, which is an Excel add-in, provides you with the ability to find the required value for a number of input cells involved in a predetermined calculation result. So, Solver can be used in situations where you want to determine the value for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required