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" wrote:

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