=RANDBETWEEN((1,100), A1))

This will work as long as the number in A1 is greater than
RANDBETWEEN(1,100):

=RANDBETWEEN(RANDBETWEEN(1,100),A1)

=RANDBETWEEN((1,100),SEEDS))

I have no idea about that one!

--
Biff
Microsoft Excel MVP


"Art W" wrote in message
...
Hello Everyone:

Sorry I posted this same question a few days ago, but I cannot find. I
assume it didn't get posted?

I am trying to create random numbers between 1 and 100. I am also trying
to
influence the output by referencing either a cell or a range. I have been
working on this problem for a long time. I think I am looking for
something
like the formulas below, but they don't work. Hopefully it will give you
an
idea of what I am trying to do.

=RANDBETWEEN((1,100), A1))
=RANDBETWEEN((1,100),SEEDS))

Thanks

Art