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)
<colgroup><col span="8"></colgroup><tbody>
</tbody>
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>