Thread: How do I create a random number generator in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim m tim m is offline
external usenet poster
  
Posts: 430
Default How do I create a random number generator in excel?
=RAND()*1000

The formula above will generate random numbers up to 999. You will want to
format the cells as number, no decimal places

"Katie" wrote:

I would like to be able to generate several random sets of 3 numbers (ex:
563, 742, 094, etc). What formula can I use to set this up in excel?
Reply With QuoteReply With Quote