|Posted: February 23, 2006, 7:08 pm - IP Logged|
it requires a conditional formula, built around a nested "IF" statement...
say column A, Cell 1 had the number 9
then say cell 1 of column B had your first "+1"
the formula would be
=IF(condition, do if true, do if false)
so, the test, or condition, will see if A1+1 is less than 10
if TRUE, just add 1 (7 becomes 8, 0 becomes 1 etc)
if FALSE, add 1, then subtract 10 (9+1=10, then -10=0)
change the 1 to whatever step you need, and this formula will keep the results in the realm of 0 to 9.
with this formula in cell B1, simply autofill over in row 1 until you get the same number back, then the rundown is complete.
good luck and let me know if this works for you.
Playing more than one ticket per game is betting against yourself.