L
Leigh
How does RND generate random numbers..is it updated the way Rand () is in Excel 2003?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
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
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
Excel 2003?Leigh said:How does RND generate random numbers..is it updated the way Rand () is in
L
Leigh
Thanks, so it doesn't have the same issues associated with it that Rand() did/does (once you install the office update)?
T
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
numbers in Excel 2003, then no, it isn't affected by those issues to the
best of my knowledge.
--
Regards,
Tom Ogilvy
did/does (once you install the office update)?Leigh said:Thanks, so it doesn't have the same issues associated with it that Rand()
J
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
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