RANDBETWEEN INSTALL

[ALee]

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then
click OK.
If necessary, follow the instructions in the setup program.

I did the first two steps several times and still got #NAME.
So, I should do the third step, but HOW?ALee

 

[Elkar]

I generally try to avoid using anything from the Analysis ToolPak whenever
possible. You never know if a user you distribute your workbook to will have
it installed or not, or if they'll even know what an Add-In is. Plus the
problem you've run into where Excel doesn't seem to want to activate it.

The RANDBETWEEN function can be duplicated using the ROUND and RAND
functions (which does not require any Add-Ins).

=ROUND(RAND()*(B1-A1)+A1,0)

Where A1 is the low number in your range, and B1 is the high number.

HTH,
Elkar

 

[ShaneDevenshire]

Hi,

The key here is that there is a bug in the Analysis Toolpak installation but
it is easy to overcome. After you have attached the Analysis Toolpak, close
Excel and reopen it.

Regarding using this feature. I am not of the opinion that you should avoid
it, instead if you are distributing it to others I suggest letting them know
to attach the Add-In or be prepared to be peppered by phone calls.

 

[ALee]

Thank you Elkar :

I still don't understand "If necessary, follow the instructions in the setup
program."
What setup program and where?

Your approach for= RANDBETWEEN(-1,1).
=ROUND(RAND*(1-(-1))+(-1),0) and just got a random set of 1 and 0 instead of
5 place decimals.

An Excel update was to no avail.

This is needed for a Maple program; it is not for distibution.

Onwards.

 

[MartinW]

To get randoms to 5 decimal places change Elkars formula to
=ROUND(RAND()*(B1-A1)+A1,5)
**note the 5) at the end

Do the same with your hard coded version
=ROUND(RAND()*(1-(-1))+(-1),5)
although you can tidy that up to
=ROUND(RAND()*(1+1)-1,5)

HTH
Martin

 

[ALee]

Thank you one and all for the informative discussion
I finally got RANDBETWEEN to work, not quite sure how.
I needed this command to put into a Maple procedure.
On other occasions, the work around would be helpful.
Muchos gracias,
A. Lee

 

[Essentials_Carol]

I came across this formula ={TABLE(E1,)} when I selected a cell and when I
double clicked the cell to edit, the function RANDBETWEEN displayed in the
Name Box. What does this formula mean? What do the curly brackets mean? Is
this part of the Analysis ToolPak addin?

Carol

 

[Mike Middleton]

Carol -

What does this formula mean? <

It's a data table. In Excel 2003 and earlier, it's entered by choosing Data

Table. In Excel 2007 and 2010 it's entered by choosing Data > What-If

Analysis > Data Table.

What do the curly brackets mean? <

Excel adds the curly brackets when you create an array-entered formula. But
={TABLE(E1,)} is special in that it can only be entered using the Data Table
command.

Is this part of the Analysis ToolPak addin? <

Data Table is not part of the Analysis ToolPak. Data Table is always
available in standard Excel.

RANDBETWEEN was a part of Analysis ToolPak in Excel 2003 and earlier. It is
a standard always-available function in Excel 2007 and 2010.

- Mike
http://www.MikeMiddleton.com