View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M John M John is offline
external usenet poster
 
Posts: 35
Default Practice Math Problems

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