Welcome Guest
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
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

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

 Page 1 of 1