Rand function error

[rdstagg]

IF(randbetween(1,100)<=G$4,RAND()*G$3,-RAND()*G$2)

I am a relative newbie. I copied this function from a book. It is supposed to generate 100 random trade outcomes in % terms.
Just returns the name error!!

 

[Iridium]

From the xl help file:

RANDBETWEEN

Returns a random number between the numbers you specify. A new random number is returned every time the worksheet is calculated.

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in

You need the Analysis Toolpak!

 

[Joe4]

Right from Excel's help on the RANDBETWEEN function:

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

Go to Tools | Add-ins and see if the Aanlysis ToolPak is listed as an option. If it is, select the check box. If not, you will need to install it, then check this box.

 

[rdstagg]

No - I have the add ins - so thats not the problem.
er sorry - after I rebooted it all worked.

Thanks
PS the message you get in your help file does not appear in my randbetween function help file!!