Forum Discussion
Solved
Help with function
I like to do workouts or rundowns whenever I play lottery; I’m trying to create a plus or minus rundown adding or subtracting 111 or 123 to original number until I return back to original number: 1...
- I’m trying to create rundown show in video in Microsoft excel
https://youtu.be/LOlUubdPB0I
Alana,
From what I understand you would like data like this:
| 231 |
| 342 |
| 453 |
| 564 |
| 675 |
| 786 |
| 897 |
| 8 |
| 119 |
| 230 |
| 341 |
| 452 |
| 563 |
| 674 |
| 785 |
| 896 |
| 7 |
| 118 |
| 229 |
| 340 |
| 451 |
| 562 |
From what I can tell you have a mistake in your column 908-111=797 not 897
Being primes 111 and 123 will not repeat until row 1001 (why, need to spend more time on that).
I work in RC reference style so it is real easy, same formula in every row starting with row three. First row is the increment and second row is the start base.
I'm not sure how to make a simple standard formula for A1 notation. Lines 5 and 6 are what the conversions of the RC style would be.
| 123 | |
| 120 | |
| 243 | =IF(R[-1]+R1>=1000,R[-1]+R1-1000,R[-1]+R1) |
| 366 | |
| 489 | =IF(4:4+$1:$1>=1000,4:4+$1:$1-1000,4:4+$1:$1) |
| 612 | =IF(5:5+$1:$1>=1000,5:5+$1:$1-1000,5:5+$1:$1) |
| 735 | |
| 858 | |
| 981 | |
| 104 | |
| 227 | |
| 350 | |
| 473 | |
| 596 | |
| 719 |