My guess is that what you are doing wrong is not reading the Excel help for
the function which you are trying to use.

It says (inter alia):
"Returns a random integer number between the numbers you specify. A new
random integer number is returned every time the worksheet is calculated.

Syntax
RANDBETWEEN(bottom,top)

Bottom is the smallest integer RANDBETWEEN will return.

Top is the largest integer RANDBETWEEN will return."

If you are hoping to get an non-integer number as an output from
RANDBETWEEN, you'll be out of luck. Other folk have suggested how to get
round this problem.
--
David Biddulph

"glenn" wrote in message
...
In using this function, I'm entering values as decimals (ie, I'm looking
for
a random number between 1.35 and 1.65. When I do this I get a result of 2.
That's obviously not a number between 1.35 and 1.65. What am I doing
wrong?