W wan Jun 3, 2004 #1 =RandBetween(1,71000) gave me #Name? What can I do to get the random number generation? Thank you for your help.
=RandBetween(1,71000) gave me #Name? What can I do to get the random number generation? Thank you for your help.
B BJ Jun 3, 2004 #3 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.
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.
W Wan Jun 3, 2004 #4 Thank you. I found that out too. -----Original Message----- Activate the Analysis Toolpak add-in via Tools|Add-Ins. . Click to expand...
Thank you. I found that out too. -----Original Message----- Activate the Analysis Toolpak add-in via Tools|Add-Ins. . Click to expand...
N Norman Harker Jun 4, 2004 #5 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
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
