Welcome Guest
Log In | Register )
You last visited December 7, 2016, 7:22 am
All times shown are
Eastern Time (GMT-5:00)

Formula for the mirror #

Topic closed. 2 replies. Last post 8 years ago by sudeo.

Page 1 of 1
PrintE-mailLink
sudeo's avatar - scene sunovermountains.jpg
New Member
Indiana
United States
Member #71741
March 2, 2009
7 Posts
Offline
Posted: March 23, 2009, 10:11 am - IP Logged

Does anyone know how to put the mirror of a number in excel?  I'm sure it's something simple but I'm not really experienced in excel.  I've done some searching for it in posts but no luck.

By mirror i mean

0=5

1=6

2=7

3=8

4=9

and vice versa

5=0

6=1

7=2

8=3

9=4

Thanks so much!!

Sudeo

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    49725 Posts
    Offline
    Posted: March 23, 2009, 10:37 am - IP Logged

    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

    A mind once stretched by a new idea never returns to its original dimensions!

      sudeo's avatar - scene sunovermountains.jpg
      New Member
      Indiana
      United States
      Member #71741
      March 2, 2009
      7 Posts
      Offline
      Posted: March 23, 2009, 1:49 pm - IP Logged

      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

      Thanks so much Raven62!!