Thanks for the welcome retxx......are you talking about calculating all of the + + + and - - - line for destinys formula, without coming up with negative numbers or numbers over 10??? try this:
for adding =IF(C13+C14>9,C13+C14-10,C13+C14) c13 & c14 being whatever cells that you are drawing your numbers from.
logic formulas are great just gotta think em through. "IF cell c13 plus cell c14 add up greater then 9, then c13 plus c14 minus 10 (gives you that single digit number your are looking for), IF NOT (greater than 9) then c13 plus c14."
for subtracting =IF(C13<C14,C13+10-C14,C13-C14)
hope this helps!
personally I have done away with all the lines except + + + and - - - if the numbers show up there they will be in the other lines anyhow. I am working on a way to reduce the pool of numbers. It is really hard to tell what 3 digits are the ones that will hit, but is it possible to just come up with 3 digits that are not going to hit? If you can do that on a consistant basis you are in the money, if you can figure out 3 numbers that are NOT going to show 70% of the time and played the remaining 343 combinations as a straight (straight would pay $500, strgt box pays only $490) you would be up $70 every 10 draws. Doesnt sound like much, suppose you play 2 or 3 dollars on every straight? Or imagine if you could get it to 80% of the time, or even better figure out 4 numbers that will not show???? Anyways that is my current approach and I am kinda jammed up in a spreadsheet that only wants to spit out even numbers at me no matter what I input.
Good Luck