| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Excel Formula Help | New Users to Excel | |||
| When inserting a simple "Sum" formula all I get is the formula. | Charts and Charting in Excel | |||
| Need help with a simple formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Simple formula for newbie! | New Users to Excel | |||
Hybrid Mode
