RANDOM_NUMBER_BETWEEN
Random number between two values

Description

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

1
RANDOM_NUMBER_BETWEEN(min: Number, max: Number) => Number
Copied!
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
Last modified 1yr ago
Export as PDF
Copy link