randbetween gives ?NAME

K

Kristjan_Thor

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

Kristján Þór
 
D

Domenic

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

Tools > Add-Ins > and check Analysis ToolPak

Hope this helps!
 
W

ww

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

Kristjan_Thor

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
 
K

Kristjan_Thor

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
 
K

Kristjan_Thor

Thank you, this was the solution :)

ww said:
You might not have the Analysis Toolpak activated.
Go to Tools>Add-Ins and make sure the Analysis Toolpak
box is checked.
Click to expand...
 
Top