Using goal seeking
Quattro Pro lets you calculate a formula backward, starting with the result and solving for a variable that produces that result. This is called goal seeking; instead of calculating an optimum solution, you change a single variable to reach the solution you specify.
When you know the result you want, but you aren’t sure how to reach it, use goal seeking to help you find the answer.
To use goal seeking |  |
|
1.
|
|
Type a formula into a cell. The formula must reference one variable cell.
|
|
2.
|
|
Click Tools
 Numeric tools Solve for. |
|
3.
|
|
Click the Range picker
 in the Formula cell box, and select the cell containing the formula. |
|
4.
|
|
In the Target value box, type the result you want from the formula.
|
|
5.
|
|
Click the Range picker
in the Variable cell box, and select the cell that can be varied to achieve a particular result. |