RANDBETWEEN function
From Planfix
The RANDBETWEEN function returns a random integer within the range between two specified numbers. Each update returns a new random integer.
Format
- RANDBETWEEN(bottom, top)
Arguments:
- bottom — Required. The smallest integer returned by the RANDBETWEEN function.
- top — Required. The largest integer returned by the RANDBETWEEN function.
Examples
| Formula | Description | Result |
|---|---|---|
| RANDBETWEEN(1,100) | Random number between 1 and 100 (changes) | changes |
| RANDBETWEEN(-1,1) | Random number between -1 and 1 (changes) | changes |