Sorry, I get the gist of an iterative calculation and how these settings work.
In the settings above, MAX number of iterations could be set to 100 and with the right formula using a circular reference it would iterate the calculation 1 cent at a time, 100 times.
But the FUND could be any value so the threshold would need to be set so the calculations stop after reaching a value no less than 0.
My problem:
I don't know how to write the formula with a circular reference to achieve this result:
It should use the value in the FUND column (A2) and repeatedly deduct (.01) from it until REMAINING FUND (C2) is 0.So far I posted in reddit but no bites, just hoping this smaller community might attract someone with the specialized knowledge to write out the formula so I can comprehend it by reverse engineering.