Pulling my hair out for a solution! Excel Gurus, haaalp!
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks