Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Best Practice | Excel Discussion (Misc queries) | |||
Good Practice | Excel Programming | |||
Best Practice | Excel Programming | |||
best practice? | Excel Discussion (Misc queries) | |||
Need Some Practice | Excel Programming |