The RAND and RANDBETWEEN functions in Google Sheets allow you to generate random numbers.

Here’s how to use each function:

RAND:

The RAND function generates a random number between 0 and 1.

Syntax: =RAND()

Example: =RAND()

This formula generates a random number between 0 and 1.

RANDBETWEEN:

The RANDBETWEEN function generates a random integer between two specified numbers.

Syntax: =RANDBETWEEN(bottom, top)

Example: =RANDBETWEEN(1, 100)

This formula generates a random integer between 1 and 100.

I hope this helps! Let me know if you have any questions.