Random Number math function?

Hello, how does the RAND() function work? I want to generate a random 6 digit number. Thank you!

You’d do RAND(111111,999999) To choose a random number between 111111 and 999999.