This is a sample document showing how the Random Number formula works.
The main random number is RND
You wont find the formula for it in the usual place.
You have to look in the ‘Value for New Rows’ option under the “Number Options” menu.
Thats because the number is computed only when a new row is created.
The second column shown uses a regular formula. It takes the RND value and computes from it a random integer between 5000 and 9500 - just to illustrate how it’s done.
The BUTTON clears the table and generates RowCount new rows (initially set to 500).
The chart shows how well the RND random numbers are distributed. Its a test of the randomness.
@Nina_Ledid, I tried using *999999999 (multiply) instead of %.999999999 (modulus), but it did not do the same at all. The modulus generates large decimal strings between 0.0 and 0.999999999, while the multiply did not.
Respect
Max