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

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!

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!!

 Page 1 of 1