*Without* using the ATP and RandBetween,
Use this formula:

=RAND()*(b-a)+a

Where "b" is the upper value, and "a" is the lower value.

So, this is what you want:

=RAND()*(1.1-0.9)+0.9

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
What happens when you hit <F9?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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.