Share this article:

What it does: The RAND() Function generates a random number between 0 and 1.

Plain English: The random function is a brother to the RANDBETWEEN() function. It generates a number in between 0 and 1, like .6231. This is a great function for creating sample data or running simulations where you need a random number generated.

Syntax: RAND()

  • (no arguments needed for this function)