combine Rand & Roundup?

[Brainless_in_Boston]

I am playing with numbers today.

I set a1:a100 with whole numbers 1 to 100. Then for b1:b100 entered =RAND()

However, instead of whole integers, I got decimals, like: 0.3356457

when I installed the right add in, Analysis ToolPak and used this formula:

=RANDBETWEEN(1,100), I got whole integers .

Anyone know why the =RAND() derived decimals? is there a way to have whole
integers generated using rand & roundup in b1:b100?

Inquiring minds wnat to knwo.

Thanks for all your help. This is a great forum.

(too bad MS doesn't have better help online!)

Mark
Boston

 

[SVC]

RAND() generates a random number between 0 and 1 (see Excel Help description
of RAND)

To generate an integer rounded up and between 0 and 100, try
=ROUNDUP(RAND()*100,0)

 

[Brainless_in_Boston]

SVC -

You are the coolest, baby!

Great formula. Thanks for posting it. Very clean and efective.

You are also right to suggest MS Help for RAND. It only generates a random
number >0 and <1 when you use =RAND()

=RAND()*100 generates a number like 95.451267

veddy interesting.

Anyone know how to use Excel to calculate pi to 50 decimals?

Mark
Boston

=========================================

 

[David J. Braden]

You're biasing the integers upward; better to use
=INT(RAND()*100+1

HTH
Dave Braden