G
Guest
Hello,
I'm guessing this should be a relatively easy problem, but I can't figure it
out.
I want to make a sheet of practice math problems for 2nd graders. I've got
the addition sheet figured out:
column x
row 1 =randbetween(1,10)
row 2 =randbetween(1,10)
and an '+ in the cell: (row 2, column x-1)
The subtraction page is the trigger for my question. I would like the same
randomized numbers, but don't want to have the kids (2nd graders!) deal with
negative numbers. Is there a way to get Excel to check the row above and set
the upperbound of the "randbetween" to that number? Would that create an
endless 'do loop' in Excel?
Many thanks,
M John
I'm guessing this should be a relatively easy problem, but I can't figure it
out.
I want to make a sheet of practice math problems for 2nd graders. I've got
the addition sheet figured out:
column x
row 1 =randbetween(1,10)
row 2 =randbetween(1,10)
and an '+ in the cell: (row 2, column x-1)
The subtraction page is the trigger for my question. I would like the same
randomized numbers, but don't want to have the kids (2nd graders!) deal with
negative numbers. Is there a way to get Excel to check the row above and set
the upperbound of the "randbetween" to that number? Would that create an
endless 'do loop' in Excel?
Many thanks,
M John