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

About a locked thread for Excel and mirrors

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

Page 1 of 1
PrintE-mailLink
JonnyBgood07's avatar - Patriots logo1.jpg
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.."

 


    Avatar
    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

      JonnyBgood07's avatar - Patriots logo1.jpg
      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.."

       


        Avatar
        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

        Now if this isnt what your asking, maybe we better let one of the pros answer..

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

        CG

          Avatar

          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