|
Need help with a simple formula
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 -- tenaj ------------------------------------------------------------------------ tenaj's Profile: http://www.excelforum.com/member.php...o&userid=32691 View this thread: http://www.excelforum.com/showthread...hreadid=535526 |
Need help with a simple formula
A2: =MOD(A1+1,10)
B2: =MOD(B1+2,10) C2: ... D2: =MOD(D1+4,10) HTH -- AP "tenaj" a écrit dans le message de ... 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 -- tenaj ------------------------------------------------------------------------ tenaj's Profile: http://www.excelforum.com/member.php...o&userid=32691 View this thread: http://www.excelforum.com/showthread...hreadid=535526 |
Need help with a simple formula
Perfect Thank you AP! -- tenaj ------------------------------------------------------------------------ tenaj's Profile: http://www.excelforum.com/member.php...o&userid=32691 View this thread: http://www.excelforum.com/showthread...hreadid=535526 |
| All times are GMT +1. The time now is 03:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com