If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
RANDBETWEEN INSTALL
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 |
#2
|
|||
|
|||
RANDBETWEEN INSTALL
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 "ALee" wrote: 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 |
#3
|
|||
|
|||
RANDBETWEEN INSTALL
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. -- cheers, Shane Devenshire "ALee" wrote: 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 |
#4
|
|||
|
|||
RANDBETWEEN INSTALL
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. "Elkar" wrote: 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 "ALee" wrote: 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 |
#5
|
|||
|
|||
RANDBETWEEN INSTALL
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" wrote in message ... 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. "Elkar" wrote: 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 "ALee" wrote: 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 |
#6
|
|||
|
|||
RANDBETWEEN INSTALL
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 "ALee" wrote: 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 |
#7
|
|||
|
|||
RANDBETWEEN INSTALL
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 "ShaneDevenshire" wrote: 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. -- cheers, Shane Devenshire "ALee" wrote: 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 |
#8
|
|||
|
|||
RANDBETWEEN INSTALL
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 "Essentials_Carol" wrote in message ... 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 "ShaneDevenshire" wrote: 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. -- cheers, Shane Devenshire "ALee" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|