You can use RANDBETWEEN but you need to load the Analysis Tool Pack.

"janiladewilly" wrote in message
...
I need a formula that looks at a number and gives me a random number that
is
less than the original number. I'm trying to set up an automatic page
with
substraction problems for my 2nd grader.