View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Use RANDBETWEEN form & include certain #'s in the range

Hello Biff,

...
P.S.

I once tested for RAND = 0.000000000000000 through 10 million iterations.

Result = 0

--


You are a funny guy :-)
In an earlier version of my UDF redw (http://sulprobil.com/html/
redw.html) I had the line (see 5th row from bottom)
While redw <= swi(i)
My friend and colleague (in a hedge fund then) complained twice that
my UDF wasn't working properly.

I took out the "=" because Rnd CAN return zero (and it did).

Good judgement comes from experience, and experience comes from ...?
(bad judgement :-)

BTW: This does not tell us RAND's shortest possible "circulation".
Actually, that would be good to know ...

Regards,
Bernd