Arbitrage bet calculator problem

[PRW71]

Hi,

I've created a spreadsheet designed to calculate the maximum profit available from an arbitrage betting situation. The first bet (the lay bet) is always at the same odds (1.5 in this case). I input the amount I ultimately want to win and it calculates the required stake. I then input the odds for the "back" bet and it runs through a circular calulation to give me the stake required for that bet to work out the maximum available profit (or minimum loss) no matter which outcome occurs. This is controlled by an "if" statement in D4.

What I'd like is a cell which adds up the profit/loss from each round, but as this requires another circular calculation the formula adds up each result from every iteration required to arrive at the profit/loss figure in the first place returning a massive total, instead of simply adding the end result to itself.

Is there a way to isolate this cell from the iteration / circular calculation process, or another way I can write the formula to give me the result I'm after?

The spreadsheet can be downloaded from here;

http://www.prwphoto.com/Arbcalc.html

Thanks very much.

Paul