You can test it depending on the range of numbers you're generating.

For example:

For random numbers from 1 to 10

Select the range A1:A20000
Enter the formula =RANDBETWEEN(1,10)
Hit CTRL ENTER

Enter this formula in C1 and copy down to C10:

=COUNTIF(A:A,ROW())

The initial calculation will take a few seconds to calculate. You will get a
relatively uniform distribution with no extreme outliers.

To generate a new set of data just press F9


--
Biff
Microsoft Excel MVP


"Candicehkjc" wrote in message
...
We use the RANBETWEEN function to generate random numbers, is this
function
certified randomness?