Thread: Help for Random Number Generation
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd Bernd is offline
external usenet poster
  
Posts: 92
Default Help for Random Number Generation
Hello,

Put into A1:
=-RAND()*1E14
and into B1:
=-A1+RAND()*(0.8-0.2)+0.2

You can substitute 1E14 by any smaller number 0.

Regards,
Bernd

Reply With QuoteReply With Quote