Why doesn't my =RANDBETWEEN function work?

[Guest]

does anyone know why my =RANDBETWEEN(1,100) formular just returns error.

?

I can't get it to work with any figures.

I'm using Excel 2003.
Sorry I can't give you any more information, I just can't get my randbetween
function to work at all.

I've tried going into INSERT>FUNCTION etc. but I can't find it in the list
either.


hope you can help

Daniel

 

[Peo Sjoblom]

Do you have ATP installed (look under tools>add-ins and Analysis ToolPak)
If not install it (you need the office/excel cd)

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

Make sure that the Analysis ToolPak is installed.

 

[Guest]

does anyone know why my =RANDBETWEEN(1,100)
formular just returns error.
[....]
Sorry I can't give you any more information

I'm sure you can. The other respondents probably guessed
correctly (you need to install the ATP). But for future
reference, at a minimum, you should post the error message
that you get.


, I just can't get my randbetween

 

[Guest]

THANKYOU TO EVERYONE WHO SUGGETED INSTLLING THE ATP

IT'S NOW WORKING

DAN