randbetween gives ?NAME

[Guest]

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

Kristján Þór

 

[Domenic]

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

Tools > Add-Ins > and check Analysis ToolPak

Hope this helps!

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Thank you, this was the solution

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