I'm glad I came back to this one to see other peoples' takes on the random
functions. Very interesting reading, and my preference for RANDBETWEEN has
just been thrown out of the window.

Thanks for the heads up on these.


"Mike Middleton" wrote:

Al -

There were many improvements in Excel 2003. For more info, see

Description of the RAND function in Excel 2003
http://support.microsoft.com/kb/828795

Description of improvements in the statistical functions in Excel 2003 and
in Excel 2004 for Mac
http://support.microsoft.com/default...product=xl2003

- Mike
www.mikemiddleton.com

"Alexander Fischer" wrote in message
ups.com...
Hello,

quite some time ago, I read some comments in this group about Excel's
RAND() function, saying that it was "awful". Is this true, and if so,
why?

Because of speed?
Or because it's not "really random"?

I'm not a mathematician, please use easy language on me :-)

Thanks,

Al