Welcome Guest
You last visited December 4, 2016, 9:25 pm
All times shown are
Eastern Time (GMT-5:00)

Topic closed. 4 replies. Last post 7 years ago by phileight.

 Page 1 of 1
Connecticut
United States
Member #61623
May 29, 2008
20581 Posts
Offline
 Posted: March 2, 2010, 10:02 am - IP Logged

Can anyone give me a step by step on how to input Ravens description below?..I just got excel the other day and was specifically interested in this particular thread.Because inevitably,I want to assign my own values to pairs/digits and this is a good starting point.

Raven62

In cell d2: =mod(a2+5,10), In cell e2: =mod(b2+5,10), In cell f2: =mod(c2+5,10)

Source:
cell a2=7, cell b2=5, cell c2=8

Result:
cell d2=2, cell e2=0, cell f2=3

"No matter how bad things may get, I'd like to thank my middle finger

for always sticking up for me.."

Florida
United States
Member #66575
October 30, 2008
3549 Posts
Offline
 Posted: March 2, 2010, 10:14 am - IP Logged

Can anyone give me a step by step on how to input Ravens description below?..I just got excel the other day and was specifically interested in this particular thread.Because inevitably,I want to assign my own values to pairs/digits and this is a good starting point.

Raven62

In cell d2: =mod(a2+5,10), In cell e2: =mod(b2+5,10), In cell f2: =mod(c2+5,10)

Source:
cell a2=7, cell b2=5, cell c2=8

Result:
cell d2=2, cell e2=0, cell f2=3

Jonny,

Is this what your looking for  ??

Result would be 203 in D, E and F .

I just did it this way so you could see how to enter formulas

CG

Connecticut
United States
Member #61623
May 29, 2008
20581 Posts
Offline
 Posted: March 2, 2010, 10:36 am - IP Logged

yes i got that part Carl..Thanks!

now how will it consistently know to output the mirror numbers in d,e,f?

"No matter how bad things may get, I'd like to thank my middle finger

for always sticking up for me.."

Florida
United States
Member #66575
October 30, 2008
3549 Posts
Offline
 Posted: March 2, 2010, 10:49 am - IP Logged

Somehow I knew it couldnt be that simple LOL

If you just copy your formula it will automatically change the cell reference to appropriate row.

CG

United States
Member #41846
June 23, 2006
459 Posts
Offline
 Posted: March 2, 2010, 8:16 pm - IP Logged

yes i got that part Carl..Thanks!

now how will it consistently know to output the mirror numbers in d,e,f?

JB   you say you are new to Excel, I may not understand your question in which case ask again.

the formula in cell D  tells Excell to add 5 (mirrow) to  the value in cell A, likewise cell E adds 5 to the value in B etc

the mod at the beginning and the 10 at the end of the formula in cells DEF tell Excell what the maximum value can be.

once you have these formulas entered you don't do anything else with them. you only see the result.

when you change any value, excel will recalculate, if recalc is on (default).  with the formulas entered change the value in A then move off that cell, the value in D should have changed.

do the same for B or C and as soon as you move to a different cell it updates

Excel can be frustrating but it's worth learning if you play with numbers.

the only stupid question is the one you don't ask, when you don't understand something

 Page 1 of 1