T
tenaj
I used the formula =IF(A1=0,9,A1-1) to get this. Notice that the top
and bottom numbers return to itself. How do I do it on the + side?
Going past 10 is when it takes me for a loop. I can understand the
simple -1 because 0 and 9 are the only two varibles but when adding it
goes up to 18.
4963
3852
2741
1630
0529
9418
8307
7296
6185
5074
4963
This is what I am trying to achieve.
Each digit is treated differently than what you see in the example
above (all of the digits in that one are -1) but what I am trying to
achieve is for the first digit (4)+1, the second digit (9)+2, the third
digit (6) +3, and the fourth digit (3)+4.
4963
5197
6321
7555
8789
9913
0147
1371
2505
3739
4963
When it goes above 10 is when it takes me for a loop. Any help will be
appreciated. Thanks.
Tenaj
and bottom numbers return to itself. How do I do it on the + side?
Going past 10 is when it takes me for a loop. I can understand the
simple -1 because 0 and 9 are the only two varibles but when adding it
goes up to 18.
4963
3852
2741
1630
0529
9418
8307
7296
6185
5074
4963
This is what I am trying to achieve.
Each digit is treated differently than what you see in the example
above (all of the digits in that one are -1) but what I am trying to
achieve is for the first digit (4)+1, the second digit (9)+2, the third
digit (6) +3, and the fourth digit (3)+4.
4963
5197
6321
7555
8789
9913
0147
1371
2505
3739
4963
When it goes above 10 is when it takes me for a loop. Any help will be
appreciated. Thanks.
Tenaj