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