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