Welcome Guest
You last visited May 26, 2017, 6:58 am
All times shown are
Eastern Time (GMT-5:00)

# Excel Help...

Topic closed. 15 replies. Last post 8 years ago by bigato1010.

 Page 1 of 2
New Member
Ho Chi Minh City
Viet Nam
Member #75840
June 13, 2009
9 Posts
Offline
 Posted: June 22, 2009, 3:48 am - IP Logged

Hi everyone, I am trying to fine tune my spreadsheet to track numbers from my previous posts. Can someone here help me out with a bit of excel. I am trying to get LotteryMath to work in excel. For example, 4+8 = 12.... but i need 4+8 = 2

Rouge

Gent
Belgium
Member #73987
April 30, 2009
33 Posts
Offline
 Posted: June 22, 2009, 3:53 am - IP Logged

In cell A1 and B1: 4 and 8

In cell C1: =A1+B1 (resulting in '12')

In cell D1: =INT(C1/10) (resulting in '1')

In cell E1: =C1-D1*10 (resulting in '2') which is the information you need.

Good luck :-)

New Member
Ho Chi Minh City
Viet Nam
Member #75840
June 13, 2009
9 Posts
Offline
 Posted: June 22, 2009, 4:03 am - IP Logged

GAMEBELGIUM,

THANK YOU! that was extremely fast....

Will be fine tuning my system and sharing it to all.... as always will be for free!

Rouge

Dallas, TX
United States
Member #60284
April 12, 2008
3856 Posts
Offline
 Posted: June 22, 2009, 4:40 am - IP Logged

=MOD(A1+B1,10)

A1 contain 4

B1 contain 8

put the formula above in C1 and it will create lotto math, best for pick 3 and pick 4.

New Jersey
United States
Member #17843
June 28, 2005
58249 Posts
Offline
 Posted: June 22, 2009, 10:05 am - IP Logged

Hi everyone, I am trying to fine tune my spreadsheet to track numbers from my previous posts. Can someone here help me out with a bit of excel. I am trying to get LotteryMath to work in excel. For example, 4+8 = 12.... but i need 4+8 = 2

Rouge

Lottery Post Search is Your Friend:

http://www.lotterypost.com/search?q=%2BExcel%2BLottery%2BMath

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

San Diego, CA
United States
Member #61467
May 24, 2008
28146 Posts
Offline
 Posted: June 22, 2009, 10:10 am - IP Logged

=MOD(A1+B1,10)

A1 contain 4

B1 contain 8

put the formula above in C1 and it will create lotto math, best for pick 3 and pick 4.

I agree.  That's the way I do it.

New Jersey
United States
Member #17843
June 28, 2005
58249 Posts
Offline
 Posted: June 22, 2009, 11:11 am - IP Logged

Hi everyone, I am trying to fine tune my spreadsheet to track numbers from my previous posts. Can someone here help me out with a bit of excel. I am trying to get LotteryMath to work in excel. For example, 4+8 = 12.... but i need 4+8 = 2

Rouge

Formulating A Search:

Search Box: Lottery Math

Date Range: All History

Forum: Mathematics

http://www.lotterypost.com/search?q=Lottery+Math&t=all&f=12

Lottery Post Search is Your Friend

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

Ohio
United States
Member #49980
February 21, 2007
34872 Posts
Offline
 Posted: June 22, 2009, 11:49 am - IP Logged

This is all new to me!! I am trying to understand it.

12345

67890

Use Mirror #'s Use prs. with your  Key* numbers the most Vivid thing in your dream go up or down on #'s.  Flip  6=9 `9=6  Bullseyes  0 or 1 for Pick 4 and the P. 5  Play the other part of doubles.  Do the Whole nine yards for a P. 4* P. 5*  or 0 thur 9  for P. 4  P. 5 from my dreams or hunches good Luck.. Write your Dreams down Play for 3 days.  Good Luck All.

Chief Bottle Washer
New Jersey
United States
Member #1
May 31, 2000
23652 Posts
Offline
 Posted: June 22, 2009, 2:35 pm - IP Logged

<Moved to Mathematics forum>

Please post in the appropriate forum ... thank you.

New Member

United States
Member #74643
May 17, 2009
7 Posts
Offline
 Posted: June 24, 2009, 2:42 pm - IP Logged

Thank you both for posting this.  I have been doing my calculations by hand, then putting them on the excel sheet...  would be way more efficient to place the formula in a cell and let the calculations begin!

Member #19992
August 9, 2005
2874 Posts
Offline
 Posted: June 29, 2009, 7:06 pm - IP Logged

Thank you both for posting this.  I have been doing my calculations by hand, then putting them on the excel sheet...  would be way more efficient to place the formula in a cell and let the calculations begin!

Is there a way to add 5 in Excel to each of the individual numbers and have it do lottery math at the same time?

Heres what I am looking for...

say the number is 3456

I want to first add 5 to the "3" to get a complete # 8456

then add 5 to second digit, 3956

then add 5 to third digit, 3406

then add 5 to last digit, 3461

but I don't want it to show regular adding but Lotto math... is ther such a formula out there to be used?

I would like my final number all into one cell not each digit into a single cell.  Any help is greatly appreciated.

We are all Lucky... just some of us don't realize it!

New Mexico
United States
Member #58526
February 18, 2008
683 Posts
Offline
 Posted: June 29, 2009, 7:32 pm - IP Logged

Is there a way to add 5 in Excel to each of the individual numbers and have it do lottery math at the same time?

Heres what I am looking for...

say the number is 3456

I want to first add 5 to the "3" to get a complete # 8456

then add 5 to second digit, 3956

then add 5 to third digit, 3406

then add 5 to last digit, 3461

but I don't want it to show regular adding but Lotto math... is ther such a formula out there to be used?

I would like my final number all into one cell not each digit into a single cell.  Any help is greatly appreciated.

let's say your 3456 is in column A (cell A1)

put this formula in cell B1........     =MOD(MID(A1,1,1)+5,10)&MOD(MID(A1,2,1)+5,10)&MOD(MID(A1,3,1)+5,10)&MOD(MID(A1,4,1)+5,10)

put this in cell B1    =MOD(MID(A1,1,1)+5,10)&MID(A1,2,1)&MID(A1,3,1)&MID(A1,4,1)       this adds five to the first digit using lotto math

put this in cell C1     =MID(A1,1,1)&MOD(MID(A1,2,1)+5,10)&MID(A1,3,1)&MID(A1,4,1)       ...adds five to the second digit

put this in cell D1     =MID(A1,1,1)&MID(A1,2,1)&MOD(MID(A1,3,1)+5,10)&MID(A1,4,1)      ...adds five to the third digit

put this in cell E1     =MID(A1,1,1)&MID(A1,2,1)&MID(A1,3,1)&MOD(MID(A1,4,1)+5,10)      ...adds five to the fourth digit

that should do what you want

New Mexico
United States
Member #58526
February 18, 2008
683 Posts
Offline
 Posted: June 29, 2009, 7:44 pm - IP Logged

Is there a way to add 5 in Excel to each of the individual numbers and have it do lottery math at the same time?

Heres what I am looking for...

say the number is 3456

I want to first add 5 to the "3" to get a complete # 8456

then add 5 to second digit, 3956

then add 5 to third digit, 3406

then add 5 to last digit, 3461

but I don't want it to show regular adding but Lotto math... is ther such a formula out there to be used?

I would like my final number all into one cell not each digit into a single cell.  Any help is greatly appreciated.

Okay, actually, I'm a little confused as to what you want.....

if you added five to each digit of your original 3456 and had the result in one cell wouldn't the resulting number be 8901????

if that's what you're looking for then use my first formula

Member #19992
August 9, 2005
2874 Posts
Offline
 Posted: June 29, 2009, 9:02 pm - IP Logged

let's say your 3456 is in column A (cell A1)

put this formula in cell B1........     =MOD(MID(A1,1,1)+5,10)&MOD(MID(A1,2,1)+5,10)&MOD(MID(A1,3,1)+5,10)&MOD(MID(A1,4,1)+5,10)

put this in cell B1    =MOD(MID(A1,1,1)+5,10)&MID(A1,2,1)&MID(A1,3,1)&MID(A1,4,1)       this adds five to the first digit using lotto math

put this in cell C1     =MID(A1,1,1)&MOD(MID(A1,2,1)+5,10)&MID(A1,3,1)&MID(A1,4,1)       ...adds five to the second digit

put this in cell D1     =MID(A1,1,1)&MID(A1,2,1)&MOD(MID(A1,3,1)+5,10)&MID(A1,4,1)      ...adds five to the third digit

put this in cell E1     =MID(A1,1,1)&MID(A1,2,1)&MID(A1,3,1)&MOD(MID(A1,4,1)+5,10)      ...adds five to the fourth digit

that should do what you want

We are all Lucky... just some of us don't realize it!

New Mexico
United States
Member #58526
February 18, 2008
683 Posts
Offline
 Posted: June 29, 2009, 11:36 pm - IP Logged