RANDBETWEEN function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=RANDBETWEEN Function |titlemode=append |keywords=planfix, Function, RANDBETWEEN, reports |description=RANDBETWEEN Function }} 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 t...") |
No edit summary |
||
| Line 6: | Line 6: | ||
}} | }} | ||
The RANDBETWEEN function returns a random integer within the range between two specified numbers. Each update returns a new random integer. | The RANDBETWEEN function returns a random integer within the range between two specified numbers. Each update returns a new random integer. | ||
== Format == | == Format == | ||
*'''RANDBETWEEN'''(bottom, top) | *'''RANDBETWEEN'''(bottom, top) | ||
Arguments: | Arguments: | ||
| Line 16: | Line 14: | ||
*top — Required. The largest integer returned by the RANDBETWEEN function. | *top — Required. The largest integer returned by the RANDBETWEEN function. | ||
== Examples == | == Examples == | ||
{| class="wikitable" | {| class="wikitable" | ||
Latest revision as of 14:44, 15 February 2024
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 |