Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2006

Tip: Looking for answers? Try searching our database.

Need help with a simple formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tenaj - 24 Apr 2006 14:56 GMT
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
Perfect Thank you AP
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.