Couldn't understand how to use goal seak .
Sir i was not able to execute goal seak operations . I tried it few times but its not clear to me what the boxes of goal seak do.
1 answers ( 0 marked as helpful)
Hi,I got to know how it works.Just set the cell to formula cells,If you already knew what answer would be coming just mention that in the 2nd cell and in the 3rd where you want the answer just select that.You will get the desired result.For the goal seek you already knew the apporx answer that would be coming so you can use that to get the required field.