Rand Between

W

wan

=RandBetween(1,71000) gave me #Name?

What can I do to get the random number generation?
Thank you for your help.
 
B

BJ

you need to have the "Analysis ToolPak" add in activated
for RandBetween to work.
If you have it activated, I don't know what your problem
is.
 
N

Norman Harker

Hi wan!

You found the disadvantage of using Analysis ToolPak functions.

If you want a method that's independent of Analysis ToolPak, you can
use:

=INT(RAND()*(B-A+1))+A

Replace B and A by cell references or (less desirably) numbers where B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
eliminate negative value from normal random number distribution 4
RANDBETWEEN generating numbers outside range 5
RANDBETWEEN() 9
How can I use the same random number twice in the same formula? 2
Associating messages with random numbers? 9
RAND() 9
What is this called in Excel or how it works? 0

Top