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