Random_number_between
  • 27 May 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Random_number_between

  • Dark
    Light
  • PDF

Given two numbers, returns a random number between them. The lower number is inclusive and the higher number exclusive, i.e. a ≤ n < b.

Function signature

RANDOM_NUMBER_BETWEEN(min: Number, max: Number) => Number
Parameter Description
Min Number to start
Max Number to end

Examples

Formula Return value
RANDOM_NUMBER_BETWEEN(1,100) 84.80714694
RANDOM_NUMBER_BETWEEN(100,1) 38.15144337
RANDOM_NUMBER_BETWEEN(1,10) 6.56814236
RANDOM_NUMBER_BETWEEN(24,120) 68.62090897

Was this article helpful?

What's Next