Thread: Random Numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default Random Numbers
Mon, 16 Apr 2007 17:36:00 -0700 from krisinvincible
:
Hi Guys,

How to generate 2 random numbers at the same time whose difference lies in a
given range.

For example,
generate a set of 2 random numbers a,b such that .45 <= (b-a) < = .60

Hint: generate a, then generate b as a + .45 + (random 0 to .15).

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Reply With QuoteReply With Quote