Comment 2 for bug 107700

Also,

if you use the random normal generator and you don't set an approximate number of digits after the decimal, the output of rand() will be correct, but the cell will round the number by itself.

e.g. in cells rounds so it has 0 digits after the decimal.

0.423489324234 -> 0
0.543589423423 -> 1

You might want to make sure you have enough digits after the decimal.