Thread: Help for Random Number Generation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dq dq is offline
external usenet poster
  
Posts: 46
Default Help for Random Number Generation
A1: =-RANDBETWEEN(0,9999999)/10000
A2: -RANDBETWEEN(-(A1+0.8)*10000,-(A1+0.2)*10000)/10000

Change the values 9999999 and 10000 according to the range and
accuracy you require.

DQ

Reply With QuoteReply With Quote