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)

[TABLE="width: 928"]
<colgroup><col span="8"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]Amount[/TD]
[TD]Grossing up[/TD]
[TD]Total Value[/TD]
[TD]Deduction[/TD]
[TD]Net Amount[/TD]
[TD]Adds[/TD]
[TD]Total Net Amount[/TD]
[TD]Must be 0[/TD]
[/TR]
[TR]
[TD="align: right"]200[/TD]
[TD="align: right"]250[/TD]
[TD="align: right"]450[/TD]
[TD="align: right"]-90[/TD]
[TD="align: right"]360[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]360[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]210[/TD]
[TD][/TD]
[TD="align: right"]210[/TD]
[TD="align: right"]-42[/TD]
[TD="align: right"]168[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]368[/TD]
[TD="align: right"]-200[/TD]
[/TR]
[TR]
[TD="align: right"]212[/TD]
[TD][/TD]
[TD="align: right"]212[/TD]
[TD="align: right"]-42.4[/TD]
[TD="align: right"]169.6[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]369.6[/TD]
[TD="align: right"]-200[/TD]
[/TR]
[TR]
[TD="align: right"]220[/TD]
[TD][/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]-44[/TD]
[TD="align: right"]176[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]376[/TD]
[TD="align: right"]-200[/TD]
[/TR]
[TR]
[TD="align: right"]226[/TD]
[TD][/TD]
[TD="align: right"]226[/TD]
[TD="align: right"]-45.2[/TD]
[TD="align: right"]180.8[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]380.8[/TD]
[TD="align: right"]-200[/TD]
[/TR]
[TR]
[TD="align: right"]230[/TD]
[TD][/TD]
[TD="align: right"]230[/TD]
[TD="align: right"]-46[/TD]
[TD="align: right"]184[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]384[/TD]
[TD="align: right"]-200[/TD]
[/TR]
[TR]
[TD="align: right"]240[/TD]
[TD][/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]-48[/TD]
[TD="align: right"]192[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]392[/TD]
[TD="align: right"]-200[/TD]
[/TR]
[TR]
[TD="align: right"]240[/TD]
[TD][/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]-48[/TD]
[TD="align: right"]192[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]392[/TD]
[TD="align: right"]-200[/TD]
[/TR]
</tbody>[/TABLE]

 

[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