RANDBETWEEN.NV

Generates a random integer that lies in a specified range. (non volatile)

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