Random Numbers???

[Crackles McFarly]

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....

 

[JW]

=RANDBETWEEN(1,15)

 

[Crackles McFarly]

=RANDBETWEEN(1,15)

OMG r u serious?
LOL, thanks a lot.

 

[Crackles McFarly]

=RANDBETWEEN(1,15)

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

 

[David Biddulph]

It's worth remembering that if you look up an Excel function in Excel help,
there is usually a "See also" link to tell you about related or similar
functions.

 

[Crackles McFarly]

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....

=ROUNDDOWN(RAND()*(50-1)+1,0)

SO THAT IT ROUNDS TO NEAREST WHOLE NUMBER?????

Is this correct???

I've tested and never see a 1 or 50 though?????

thnks

 

[David Biddulph]

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?

 

[T. Valko]

If you want a random number between 1 and 50 (inclusive):

=INT(1+50*RAND())

 

[David Biddulph]

Does ROUNDDOWN sound as if it rounds to the *nearest* whole number, or does
it sound as if it might always round *down*? [Again Help will help.]

I wouldn't expect a 50 from that formula, but I do expect (and get) a 1. If
you want a 50 too, then ditch the -1 from the formula, or use
=RANDBETWEEN (1,50).

 

[T. Valko]

Here' a generic formula:

=INT(lower_boundary+(upper_boundary-lower_boundary+1)*RAND())

 

[Crackles McFarly]

If you want a random number between 1 and 50 (inclusive):

=INT(1+50*RAND())

that worked great, thanks!

 

[T. Valko]

that worked great, thanks!

You're welcome. Thanks for the feedback!