Hi Dana,
Copied from my Excel 2003 help:

"Returns a random integer number between the numbers you specify. A new
random integer 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."


--
Ken Hudson


"Dana DeLouis" wrote:

Hi. Hmmm. Help in Excel 2003 doesn't actually say that it returns
Integers.
If you do the following, and copy down, you will see that it only returns
Integer values.

=RANDBETWEEN(1,100)

Maybe something like:
=0.9+RAND()*0.2

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Nat" wrote in message
...
I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a
multiplier
it multiplies by one. In other words, the cell isn't functioning by giving
me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that I
have to hit to get the function to operate - but I don't know what it is.