Can I randomize whole numbers in my excel sheet?
 

=INT(RAND()*100)
will generate 2 digit whole numbers


"AngeCP7" wrote in message
...

You can use the =RANDBETWEEN(bottom,top)

Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378972

If you want non-repeating random numbers, see

http://www.mcgimpsey.com/excel/randint.html

for one way.

Note: RANDBETWEEN requires the Analysis ToolPak add-in be loaded.

See also JE McGimpsey's site for limitations on the RANDBETWEEN function and
workarounds to ensure you get 100 non-duplicated numbers.

http://www.mcgimpsey.com/excel/udfs/randint.html





On Tue, 14 Jun 2005 08:58:17 -0500, olasa
wrote:


You can use the =RANDBETWEEN(bottom,top)

Ola