File | Edit | View | Insert | Format | Tools | Data | Window |
What is Goal Seek?
This option is used to estimate the value. This option is applied on the cell containing the formula.
-Tools - Goal Seek, this will open a dialog box with following options.
-Set Cell – type the name of the cell containing the formula.
-To Value – type the desired value.
-By Changing Cell – type the name of the cell which you want to be changed.
This option is used to estimate the value. This option is applied on the cell containing the formula.
-Set Cell – type the name of the cell containing the formula.
-To Value – type the desired value.
-By Changing Cell – type the name of the cell which you want to be changed.