Welcome Guest
Log In | Register )
You last visited January 20, 2017, 5:13 pm
All times shown are
Eastern Time (GMT-5:00)

excel

Topic closed. 1 reply. Last post 5 years ago by thinktank.

Page 1 of 1
PrintE-mailLink
capu's avatar - clint eastwood-cigarette-money-case.jpg
chicago,il
United States
Member #121142
January 3, 2012
272 Posts
Offline
Posted: January 23, 2012, 9:43 pm - IP Logged

any one here good with excel ? like if i give you  codes for one number would u be able to do it like

 

pick 3 : 990

 

code            (+1) -1 Same

new number   0    8   0               from 990

    Avatar
    homeland security
    United States
    Member #82523
    November 15, 2009
    98 Posts
    Offline
    Posted: January 24, 2012, 9:56 am - IP Logged

    any one here good with excel ? like if i give you  codes for one number would u be able to do it like

     

    pick 3 : 990

     

    code            (+1) -1 Same

    new number   0    8   0               from 990

    hey capu, I haven't been here for a while now...my job has going.....but the answer to your question is simple... You could do it in a macro or just within your excel cells!  So my question to you is..How good are you at interfacing or implementing excel functions within excel's cells?  I think that would be your easiest route, however, I don't understand your math...

    +1 added to 9 = 0  ....I understand

    -1 added to 9 = 8  ...... I understand

    -1 added to 0 = same  ??? .. I don't understand this line

    what is the rule that governs the logic that a variable which is (-1) added to a given which is (0) equals your given which is (0) ? because I would have thought that -1 added to 0 equals 9