How to siphon value away from an iterative calculation?

**Sayle** · 01-17-2014, 08:26 AM

I have a fairly basic problem: three people with different amounts of money. Each 'turn', they take 10% of what they have and pass the rest to the players either side of them. The amount they pass to each varies, but that isn't important.

The problem is that I need some way to record the 10% (or 20%, or 30%, or whatever) that they take off on each iteration. Currently the iteration will simply reset the value in the field. So if they had $100 in iteration one, it reads $10. But another iteration (with the amount of money in the loop decreasing), it changes to a lower value and the '$10' is lost. Is there any way you can have a formula that takes a value from the iteration each loop and isn't in turn changed each time? I basically just want to have 'value loop 1'+'value loop 2'+'value loop 3', etc. As it stands I lose the information.

**MrShorty** · 01-17-2014, 09:47 AM

It will be very hard to give a specific answer without a spreadsheet that shows exactly how you have the spreadsheet set up.

When I have an iterative calculation and I want to see the result of each iteration, I almost always organize the spreadsheet where each "iteration" is calculated in its own row. Something like:

Please Login or Register  to view this content.

With the correct combination of relative and absolute references, this is quick and easy to build, leaves the result of each iteration available, can be extended for about 1M iterations (if I really need that many).