RAND
Returns a random decimal number between 0 and 1 that may be up to 9 decimal places.
Returns a random decimal number between 0 and 1 that may be up to 9 decimal places.
Syntax of Excel Rand Formula:
=RAND()
In words:
=Give a random decimal number somewhere between 0 and 1.
=RAND() can return any number between 0 and 1. It changes every time. To cycle through different results press F9 key on the keyboard