Goal seek
Definition
Goal seek allows you to change the result of given set of conditions by changing one specific value.
You can find this under DATA - What if analysis. See below
Example:
We have a profit/loss report that look like follows:
| Product price | 1 000.00 |
| Tax | 14% |
| Tonnages | 65473 |
| Total sales | 9 166 220.00 |
If we want to change the total sales to exactly 10 000 000, by changing the product price we can use goal seek for this.
"Set cel"l will be the cell where the total sales number is in, and "by changing cell" is where the product price is in.
You will get the following message:
Press ok, and the result will ook like follows:
| Product price | 1 090.96 |
| Tax | 14% |
| Tonnages | 65473 |
| Total sales | 10 000 000.00 |
Always remember the "by changing cell" should be a value and not a formula.
<-----Back to index
