Page 226 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

If you are certain that a solution to the formula you are trying to resolve does exist, check out the following
troubleshooting tips.
1 Double check Goal Seek parameters
First off, make sure the Set cell refers to the cell containing a formula, and then, check if the formula cell depends,
directly or indirectly, on the changing cell.
2 Adjust iteration settings
In your Excel, click File > Options > Formulas and change these options:
• Maximum Iterations - increase this number if you want Excel to test more possible solutions.
• Maximum Change - decrease this number if your formula requires more accuracy. For example, if you are
testing a formula with an input cell equal to 0 but Goal Seek stops at 0.001, setting Maximum Change to
0.0001 should fix the issue.
The below screenshot shows the default iteration settings

3 No circular references
For Goal Seek (or any Excel formula) to work properly, the involved formulas should not be co-dependent on each
other, i.e. there should be no circular references.

That's how you perform What-If analysis in Excel with the Goal Seek tool. I thank you for reading and hope to see
you on our blog next week!

Macros & VBA

213

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77