By "didn't work", do you mean that you got the error #NAME?
And did you look up RANDBETWEEN in Excel help to see what to do to make the
function work?
--
David Biddulph

"Crackles McFarly" wrote in message
...

USING EXCEL 1997, that didn't work....?

On Mon, 15 Oct 2007 13:53:03 -0700, JW sayd
the following:

=RANDBETWEEN(1,15)

Crackles McFarly wrote:
I know the 'rand()' generates a random number.
Here comes a dumb question.

I need one from exactly 1 to X, how do you do this?


thanks....