Goal Seek Formula or Same function Formula

[Excelawy]

Hello

i have the following table, i have to do goal seek formula on every row to get the value Column H to 0 by Changing in Column B

Could I Change the Number in Column H to zero for All Rows in one Step (preffered not using VBA)

A	B	C	D	E	F	G	H
Amount	Grossing up	Total Value	Deduction	Net Amount	Adds	Total Net Amount	Must be 0
200	250	450	-90	360	200	360	0
210		210	-42	168	200	368	-200
212		212	-42.4	169.6	200	369.6	-200
220		220	-44	176	200	376	-200
226		226	-45.2	180.8	200	380.8	-200
230		230	-46	184	200	384	-200
240		240	-48	192	200	392	-200
240		240	-48	192	200	392	-200

<colgroup><col span="8"></colgroup><tbody>
</tbody>

 

[Truiz]

Re: Help! Goal Seek Formula or Same function Formula

What is the formula on column H?

 

[Truiz]

Re: Help! Goal Seek Formula or Same function Formula

Please share all the formulas actually, since you want to go the VBAless way

 

[Excelawy]

Re: Help! Goal Seek Formula or Same function Formula

Column H Contains the following formula,

=F1-G1