Syntax
Rand()Examples
=Round(Rand() * 100, 0)A random number from 0 to 100
Maker notes
- Rand is volatile: it gets a new value whenever the formula recalculates. Store it with Set to keep one value.
Rand
Returns a random decimal number from 0 up to, but not including, 1.