Excel 2003-RND() vs Rand()

[Leigh]

How does RND generate random numbers..is it updated the way Rand () is in Excel 2003?

 

[Tom Ogilvy]

rnd is part of vba 6. VBA6 hasn't changed since xl2000 - at least there
hasn't been a version change.

http://support.microsoft.com/default.aspx?scid=kb;en-us;231847&Product=vbb
INFO: How Visual Basic Generates Pseudo-Random Numbers for the RND Function

--
Regards,
Tom Ogilvy

How does RND generate random numbers..is it updated the way Rand () is in

Excel 2003?

 

[Leigh]

Thanks, so it doesn't have the same issues associated with it that Rand() did/does (once you install the office update)?

 

[Tom Ogilvy]

I am not sure what issues you refer to. If you mean the negative random
numbers in Excel 2003, then no, it isn't affected by those issues to the
best of my knowledge.

--
Regards,
Tom Ogilvy

Thanks, so it doesn't have the same issues associated with it that Rand()

did/does (once you install the office update)?

 

[Jerry W. Lewis]

If you are referring to the production of negative numbers by RAND() in
the original release of Excel 2003, that was repared by a hotfix earlier
this year. With the hotfix, RAND() should have considerably better
statistical properties than the VBA Rnd() function.

Jerry