# Doing a progression for roulette and overcoming Circular Ref Warning.

#### wedding

##### Board Regular
 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?

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### wedding

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

#### VoG

##### Legend
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

##### Board Regular
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

Bump!

Replies
5
Views
118
Replies
0
Views
123
Replies
4
Views
171
Replies
10
Views
114
Replies
3
Views
91

1,195,936
Messages
6,012,393
Members
441,695
Latest member
MickRobertson

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back