J
jason
How does the built in Random number function in Excel work?
Is it truly random?
Is it truly random?
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.
N
Norman Harker
Hi Jason!
For Excel 2003 see:
Excel Statistical Functions: RAND
http://support.microsoft.com/default.aspx?scid=kb;en-us;828795&Product=xlw
But also makes sure you see:
The RAND function returns negative numbers in Excel 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;834520&Product=xlw
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
For Excel 2003 see:
Excel Statistical Functions: RAND
http://support.microsoft.com/default.aspx?scid=kb;en-us;828795&Product=xlw
But also makes sure you see:
The RAND function returns negative numbers in Excel 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;834520&Product=xlw
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
S
Serkan Gur
It uses the timer in the PC as its base, believes the time
elapsed since the PC was turned on is random enough.
elapsed since the PC was turned on is random enough.
J
Jerry W. Lewis
It may use the clock for the first value, but subsequent values are
calculated mathematically using a process (documented in Knolwedge Base)
that approximates randomness in many ways.
Jerry
calculated mathematically using a process (documented in Knolwedge Base)
that approximates randomness in many ways.
Jerry