Doing a progression for roulette and overcoming Circular Ref Warning.

[wedding]

Cell A to be automated:					Total	Win	Net
1	1	1	1	1		5	5	36	31
1	1	1	1	1		5	10	36	26
1	1	1	1	1		5	15	36	21
1	1	1	1	1		5	20	36	16
1	1	1	1	1		5	25	36	11
1	1	1	1	1		5	30	36	6
1	1	1	1	1		5	35	36	1
2	2	2	2	2		10	45	72	27
2	2	2	2	2		10	55	72	17
2	2	2	2	2		10	65	72	7
3	3	3	3	3		15	80	108	28
3	3	3	3	3		15	95	108	13
4	4	4	4	4		20	115	144	29
4	4	4	4	4		20	135	144	9

<tbody>
</tbody>

Hi guys, as above is my progression table for roulette, the table is what I want to achieve. Lets say we are betting 5 numbers so we start we 1 unit on each number. On the 8 step of the progression we cannot do 1 1 1 1 1 anymore as it will result in a negative. What I want is for the excel to show how much I have to bet on each number in order to profit in the next step. I was thinking of using the formula if =if(J3<1,A2+1,A2) but I get the Circular Ref Warning as the cells are linked. Is there anyway for this to work guys?

 

[wedding]

Hope someone can help me out here a I don't mind sending you a small fee thanks!

 

[VoG]

Please note that offering payment is against the spirit of the forum.

Have you tried going to Tools > Options > Calculation tab and setting Iterations to 1. That should circumvent the circular reference warning.

 

[wedding]

Sorry about that I did not reliased. i tried using the formula =if(J3<1,A2+1,A2) but instead of doing what i want I got this instead:

1 1 1 1 1
1 1 1 1 1
1 1 1 1 1
1 1 1 1 1
1 1 1 1 1
1 1 1 1 1
1 1 1 1 1
2 2 2 2 2
3 3 3 3 3
4 4 4 4 4

 

[wedding]

Bump!