Question

to find target value
what option we use in ms excel
​

Answer 1

Answer:

On the Data tab, in the Data Tools group

Explanation:

click What-If Analysis, and then click Goal Seek. In the Set cell box, enter the reference for the cell that contains the formula that you want to resolve. In the example, this reference is cell B4. In the To value box, type the formula result that you want.