What purpose does Goal Seek Solve?
Asked By
0 points
N/A
Posted on - 10/19/2012
It is related to find out the result of a formula would be if only one variable is to be changed in Ms excel. When we know the desired result of a single formula but not the input value the formula needs to determine the result, we can use the Goal Seek feature.
Ms excel varies the value in one specific cell until a formula that's dependent on the cell returns the result we want.
FINDING VALUE USING GOAL SEEK