Need help with a simple formula

  • Thread starter Thread starter tenaj
  • Start date Start date
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
 
Back
Top