W
wan
=RandBetween(1,71000) gave me #Name?
What can I do to get the random number generation?
Thank you for your help.
What can I do to get the random number generation?
Thank you for your help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Aladin Akyurek
Activate the Analysis Toolpak add-in via Tools|Add-Ins.
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.
for RandBetween to work.
If you have it activated, I don't know what your problem
is.
W
Wan
Thank you. I found that out too.
-----Original Message-----
Activate the Analysis Toolpak add-in via Tools|Add-Ins.
.
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
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