Using Randbetween gives result ?NAME.
Content of cell =randbetween(1,10)
Do anyone have a solution?

Kristján Þór

You'll need to enable the Analysis ToolPak add-in...

Tools Add-Ins and check Analysis ToolPak

Hope this helps!

In article ,
"Kristjan_Thor" wrote:

Using Randbetween gives result ?NAME.
Content of cell =randbetween(1,10)
Do anyone have a solution?

Kristj‡n ޗr

You might not have the Analysis Toolpak activated.
Go to ToolsAdd-Ins and make sure the Analysis Toolpak
box is checked.

"Kristjan_Thor" wrote:

Using Randbetween gives result ?NAME.
Content of cell =randbetween(1,10)
Do anyone have a solution?

Kristján Þór

Thank you Domenic for your help.
Do you know how I get decimals, I do not get decimals, only whole numbers
without decimals.
Regards
Kritstjan Thor

"Domenic" wrote:

You'll need to enable the Analysis ToolPak add-in...

Tools Add-Ins and check Analysis ToolPak

Hope this helps!

In article ,
"Kristjan_Thor" wrote:

Using Randbetween gives result ?NAME.
Content of cell =randbetween(1,10)
Do anyone have a solution?

Kristj€¡n Þ€”r

Hi Domenic
Found out how to get decimals, divide result with chosen number of decimals,
10 for one decimal 100 for two e.t.c.
Thank you for your effort :-)

Kristján Þór


"ww" wrote:

You might not have the Analysis Toolpak activated.
Go to ToolsAdd-Ins and make sure the Analysis Toolpak
box is checked.

"Kristjan_Thor" wrote:

Using Randbetween gives result ?NAME.
Content of cell =randbetween(1,10)
Do anyone have a solution?

Kristján Þór

Thank you, this was the solution :-)

"ww" wrote:

You might not have the Analysis Toolpak activated.
Go to ToolsAdd-Ins and make sure the Analysis Toolpak
box is checked.

"Kristjan_Thor" wrote:

Using Randbetween gives result ?NAME.
Content of cell =randbetween(1,10)
Do anyone have a solution?

Kristján Þór