=RANDBETWEEN() not working

[B_Carpet]

hi,

I am trying to use the =RANDBETWEEN() function in Excel XP however it does not seem to be working for me. I want excel to randomly pick a number between 1 and 100 so using their example on the help i put in

=RANDBETWEEN(1,100)

into my cell. Now when i press enter off this i get

#NAME?

what am i doing wrong and how can i fix it?

I am new to doing functions on excel so please help

cheers in advance

[Domenic]

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

Tools > Add-Ins > and check Analysis ToolPak

Hope this helps!

hi,

I am trying to use the =RANDBETWEEN() function in Excel XP however it does not seem to be working for me. I want excel to randomly pick a number between 1 and 100 so using their example on the help i put in

=RANDBETWEEN(1,100)

into my cell. Now when i press enter off this i get

#NAME?

what am i doing wrong and how can i fix it?

I am new to doing functions on excel so please help

cheers in advance

[B_Carpet]

worked perfectly cheers :D