RAND.NV

Generates a uniformly distributed random number in the range 0 (inclusive) to 1 (exclusive). (non volatile)

link - help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html