InOverMyH3ad
New Member
- Joined
- Sep 17, 2018
- Messages
- 9
I am killing myself trying to solve a problem of pennies!
Source 1 is a pricing sheet that has a total at the bottom. We frequently use goal seek to adjust margin to get a desired number.
Accounting 2 is a sheet for accounting that takes numbers from Source 1 and regroups them. The numbers from Accounting 2 should match the total to Source 1.
There is a simple check on sheet two that says Source 1 total price - Accounting 2 total price and has conditional formatting if it doesn't =0
Due to rounding on Accounting 2, I'm running in to scenarios where I can be .01 off. I would like to take whatever the resulting difference is in my check and add it to one of my groups on the Account 2 sheet to make the difference 0. The problem is this creates a circular reference. I started looking in to iterative functionality but the problem is when I perform goal seek on the source sheet, the difference is stored every iteration goal seek does until it reaches the goal number; I just need it to be done at the very end.
Is this possible?
Source 1 is a pricing sheet that has a total at the bottom. We frequently use goal seek to adjust margin to get a desired number.
Accounting 2 is a sheet for accounting that takes numbers from Source 1 and regroups them. The numbers from Accounting 2 should match the total to Source 1.
There is a simple check on sheet two that says Source 1 total price - Accounting 2 total price and has conditional formatting if it doesn't =0
Due to rounding on Accounting 2, I'm running in to scenarios where I can be .01 off. I would like to take whatever the resulting difference is in my check and add it to one of my groups on the Account 2 sheet to make the difference 0. The problem is this creates a circular reference. I started looking in to iterative functionality but the problem is when I perform goal seek on the source sheet, the difference is stored every iteration goal seek does until it reaches the goal number; I just need it to be done at the very end.
Is this possible?