Formulating +- cells for box method

Reply #7

eastfield — Thu, 25 Jan 2018 16:17:03 GMT

Hi All

i have hit a hiccup.I tried to input +2 and -2 in another box but it is giving me minus numbers for example if I start at 39 and add 2 i get 41,43,45 and so on when I want it to loop and read 2,4,6 ect ...

The samne error is happening with -2. When i start at 39 for example and go back -2 in each cell when I arrive at 1 the next readings are -1,-3-5,-7 when it should read 38,36,34 ect....

How do I formulate a loop into the cell forumula so it moves from 39............ [ More ]

Reply #6

eastfield — Mon, 15 Jan 2018 20:28:59 GMT

Wow! AllenB and Raven62 both formulas fit.Now I can play around with date reference to get a pool of numbers to wheel.I got the idea from Rhonda Collins.Will keep working on it and let you know how it goes.

Thanks for the adding momentum.

Eastfield

Reply #5

Raven62 — Mon, 15 Jan 2018 17:55:00 GMT

L8=MOD(K8,39)+B2

B2=+1, +2, +3, etc.

Reply #4

Raven62 — Mon, 15 Jan 2018 17:49:27 GMT

L8=MOD(K8,39)+1

Reply #3

AllenB — Mon, 15 Jan 2018 15:46:50 GMT

Formula begins in Start If 39 is in Cell E5, and Start is D5 then Formula is =if(E5+1=40,1,E5+1). Follow your arrow and use the Correct Cells and you re there.

For the Minus the formula is =if(E5-1=0,39,E5-1). Again follow your arrows and you will have it.

Good Luck

Reply #2

eastfield — Mon, 15 Jan 2018 07:27:35 GMT

Hi

If you can write a program which will allow me to change the parameters like instead of -+ 1 have -2 +2 or alteranate the cells with -1,+2 that would be great.I would pay you for it.

Regards

Eastfield

Reply #1

lakerben — Mon, 15 Jan 2018 04:15:05 GMT

Welcome. There are many good excel programmers that can write one for you.

Formulating +- cells for box method

eastfield — Sun, 14 Jan 2018 21:57:35 GMT

Hi all

I am trying to use the plus one minus one box system for the 5/39 Thunderball lottery we have in the England. I am really hoping to use Excel to automatically calculate the + - boxes to help select numbers for the game.See below

winning number from current game:3,23,26,34,39

plus 1

3

?

23

?

26

finish

34

start

39

3