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

Signature
tenaj
Ardus Petus - 24 Apr 2006 16:09 GMT
A2: =MOD(A1+1,10)
B2: =MOD(B1+2,10)
C2: ...
D2: =MOD(D1+4,10)
HTH
--
AP
> 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?
[quoted text clipped - 37 lines]
>
> Tenaj
tenaj - 24 Apr 2006 18:55 GMT