https://www.lotterypost.com/thread/191093 Lottery Post Forum Topic: Formula for the mirror # en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/191093/1258780 https://www.lotterypost.com/thread/191093/1258780 Mon, 23 Mar 2009 17:49:33 GMT sudeo Thanks so much Raven62

]]> sudeo https://www.lotterypost.com/thread/191093/1258544 https://www.lotterypost.com/thread/191093/1258544 Mon, 23 Mar 2009 14:37:09 GMT 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

]]> Raven62 https://www.lotterypost.com/thread/191093 https://www.lotterypost.com/thread/191093 Mon, 23 Mar 2009 14:11:51 GMT sudeo 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

]]> sudeo