Influencing RandBetween

[Art W]

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

 

[T. Valko]

=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!

 

[Jim Cone]

You did get a reply to your post of Aug 06, 2009;
about two hours after your post.
'--
My free Special Randoms workbook will generate random numbers,
between your max/min limits, that average a specified amount.
Email and ask for it. Please use your real name and indicate
your geographic location. Remove xxx from my email address...
(e-mail address removed)
'--
Jim Cone
Portland, Oregon USA



"Art W" <[email protected]>
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

 

[Jacob Skaria]

Your previous post

http://www.microsoft.com/office/com...e2a2&mid=fdf5eeac-cc7e-4fbc-8e2d-08a601972664

If this post helps click Yes