wedding
Board Regular
- Joined
- Jun 12, 2010
- Messages
- 127
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?