Excel Help

Reply #8

JADELottery — Thu, 11 Oct 2018 14:22:47 GMT

Number

Mod 5

Lo Hi

Range

Even Odd

Vtrac

N

MOD(N,5)

INT(N/5)

INT(N/2)

MOD(N,2)

MOD(N,5)+1

0

0

0

0

0

1

1

1

0

0

1

2

2

2

0

1

0

3

3

3

0

1

1

4

4

4

0

2

0

5

5

0

1

2

1

1

6

1

1

3

0

2

7

2

1

3

1

3

8

3

1

4

0... [ More ]

Reply #7

gtpapi987 — Thu, 11 Oct 2018 06:41:35 GMT

Reply #6

scj2574 — Mon, 08 Oct 2018 18:29:33 GMT

Thanks everyone will try this

Reply #5

lottologix — Sun, 07 Oct 2018 15:25:50 GMT

There may be a bug in either the MOD or MODE function. Cannot remember which. I just figured out a different workaround for what I was doing at the time. This was for an older version of excel like 2000 or 2003. They probably fixed it by now I would think.

Reply #4

AllenB — Sun, 07 Oct 2018 15:07:28 GMT

I am going to have to learn more about this MOD function.

Never used it before.

Thanks for the Inspiration.

Reply #3

AllenB — Sun, 07 Oct 2018 15:04:45 GMT

Boy, that was a Brain Spasm. You would have to change the + sign to a minus for that to work.

Need more examples.

Reply #2

Raven62 — Sun, 07 Oct 2018 15:02:52 GMT

=MOD($A$1+$A$2,5

Reply #1

AllenB — Sun, 07 Oct 2018 14:59:44 GMT

I see a pattern in your 2 Examples. If you add 1 to the right side of the Equation, you get the answers in the example.

Hope that helps.

Excel Help

scj2574 — Sun, 07 Oct 2018 14:23:15 GMT

Can someone on LP tell me lets say for ex: I want to make 3+2=0 in excel or 4+2=1? I know some of the basic formulas, If I had 3 in cell A1, 2 in cell A2 what formula would I put in cell A3 to make A1 A2 =0? All lotto math and im only using values 0 1 2 3 4 not 5 6 7 8 9? Thanks