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:
120
019
908
897
786
675
564
453
342
231
120
when I use the add function it gives me a different result that I don’t want. I need help with function and formula.
120
019
908
897
786
675
564
453
342
231
120
when I use the add function it gives me a different result that I don’t want. I need help with function and formula.
2 Replies
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
