6.2.1 Goal Seek

Goal seek is useful when a value depends on another value. The relationship can be simple, as in Celcius to Farenheit convertion, or it can be somewhat complex, as in interest rate versus monthly payment.

For those of us who can handle algebra, goal seek is not always necessary. One can solve an equation symbolically to express one variable using another variable. For the rest of us, goal seek works like a charm without any need of algebra!

Note that sometimes it is not easy to solve an equation symbolically. This means goal seek actually has value even for those of us who can handle algebra.

For most of us, goal seek can be used to convert units. If you now how to convert from unit A to unit B, goal seek helps you convert from unit B back to unit A.