|Posted: July 25, 2011, 11:07 am - IP Logged|
hello just wanted to ask if there is a formula for pick 3 mirrors for excel? like for example IN COLUMNS ABC are the winning numbers ang the mirrors are in cloumns EFG. is there a formula that i can use for it? tnx alot in advance. :)
A B C D E F G
1 1 2 3 6 7 8
Cell E1: =MOD(A1+5,10)
Cell F1: =MOD(B1+5,10)
Cell G1: =MOD(C1+5,10)
A mind once stretched by a new idea never returns to its original dimensions!