puzzle with goal seek behavior

[Harvey Waxman]

A worksheet contains a column with values that depend on a certain cell
value
A second column contains values dependent on the values in the first
column

If I change the value in the cell the values in the first column change
but the not the values in the second column

If I manually change values in the first column the changes are
reflected in the second column.

I have copied the data to a new workbook with the same behavior.

No cells are locked.

If I use goal seek to change the total of the second column by looking
for a new value for the cell it never stops searching.

Any thoughts?

 

[Niek Otten]

Please post your formulas

 

[Harvey Waxman]

Please post your formulas

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

L5 12.12% a value (there are others as well but they behave the same)

O10 =IF(M10="",H10*(1+$L$5),L10)
P10 =IF(M10<>"",L10*$X$24/1000,$X$26*O10/1000)

I have a second sheet with similar data and formulas for other tax years
that works fine.

As I said if I manually change values in O the column totals change
If I change L5 manually the values in O change but P remains unchanged

If I change X24 or X26 the totals change but goal seek won't work

 

[Harvey Waxman]

Please post your formulas

[/QUOTE]

Found the answer. Thanks