Can't resolve circular ref

[Jeff]

Column A has Standard rate entered as £s
Column B has Discount amount £s
Column C has percentage dicount given based on =(A-B)/A
(cell formatted as percentage to two decimal places)

This means that if the Standard rate or the discount
amount is changed the percentage recalculates
automatically.

This is fine for when the discount amount is changed.
This is how we want it to work.

What is not fine is that if the standard rate is changed
the percentage recalculates. What we want is for the
discount amount to change based on the current percentage
discount. As the percentage cell is already calculated I
can't see how to get around the circular ref.

 

[Frank Kabel]

Hi
iuf I understood you correctly this is not possible with formulas
alone. This would require VBA

--
Regards
Frank Kabel
Frankfurt, Germany

Column A has Standard rate entered as £s
Column B has Discount amount £s
Column C has percentage dicount given based on =(A-B)/A
(cell formatted as percentage to two decimal places)

This means that if the Standard rate or the discount
amount is changed the percentage recalculates
automatically.

This is fine for when the discount amount is changed.
This is how we want it to work.

What is not fine is that if the standard rate is changed
the percentage recalculates. What we want is for the
discount amount to change based on the current percentage
discount. As the percentage cell is already calculated I
can't see how to get around the circular ref.