RANDBETWEEN function

From Planfix
Revision as of 08:36, 9 February 2024 by Dmitri (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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


Go To

Retrieved from "http://planfix.com/help/index.php?title=RANDBETWEEN_function&oldid=18766"