RANDBETWEEN function

From Planfix
Revision as of 14:44, 15 February 2024 by Aliona (talk | contribs)
(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