Pulling my hair out for a solution! Excel Gurus, haaalp!

[maa0043]

I need to have 3 columns in my excel: Amount, Percent and Divisor

- Amount and Percent need to be editable.
- Amount should calculate as Percent*Divisor/100
- Percent should calculate as Amount/Divisor*100
- Whenever Amount is updated, Percent should update and vice-versa.

Example:
Amount = 100, Percent = 1, Divisor= 1000 (100 is 1% of 1000)
Update Amount to 200, should result in:
Amount = 200, Percent = 2, Divisor= 1000 (200 is 2% of 1000)
Update Percent to 3, should result in:
Amount = 300, Percent = 3, Divisor= 1000 (300 is 3% of 1000)

Possible? I think that i can't have a formula column as editable? Any geniusiscious workarounds?

[TMS]

Welcome to the forum maa0043: please take a moment to update your thread title to something more specific as per the forum rules ... possibly, Circular Reference with dependent cells.

Brief answer as something to be going on: a cell can have a formula or a value but not both. If you have two formulae that point to each other, as in this case, you create a circular reference. AFAIK, the only way to do what you want is to use a VBA Worksheet Change event.

Regards