Bazman
04-18-2010, 06:12 PM
Hi there,
Currently my excel rand function when called in VBA repeatedly produces a random value of circa 1.788*10-7.
When this is fed into NormInv(1.788*10-7,0,1).
I get -5,000,000.
Surely this figure is too small to occur relatively fequently?
Its occus every approx 4000 times rand is called?
I heard that the rand() in earlier version of excel could be ropey is this an example? If so how do I fix or what alternatives do I have?
Thanks
Baz
Currently my excel rand function when called in VBA repeatedly produces a random value of circa 1.788*10-7.
When this is fed into NormInv(1.788*10-7,0,1).
I get -5,000,000.
Surely this figure is too small to occur relatively fequently?
Its occus every approx 4000 times rand is called?
I heard that the rand() in earlier version of excel could be ropey is this an example? If so how do I fix or what alternatives do I have?
Thanks
Baz