RND(x)

Returns a random whole number between 0 and the input number. To get a series of 5000 random numbers between 0 and 1, use RND(5000)/5000. Alternatively, use RANDBETWEEN(0,1).

See also:

RANDBETWEEN