RANDCONST
Description
Returns a random floating point number. This function is similar to RAND() except
that RANDCONST() generates a random floating point number only when you make the
function run (for example, you select
).
Syntax
RANDCONST([
low_bound
], [
high_bound
])
- low_bound: The low bound on the generated random number. This number is inclusive (the value might be returned as a result). If you omit the argument, the function uses 0 as the value.
- high_bound: The high bound on the generated random number. This number is inclusive (the value might be returned as a result). If you omit the argument, the function uses 1 as the value.
Example
Formula | Result |
|---|---|
=RANDCONST() | varies (between 0 and 1) |
=50*RANDCONST() | varies (between 0 and 50) |
=RANDCONST()*(50-10)+10 | varies (between 10 and 50) |
Notes
- If you need one-time-only calculation, for any formula, enclose it in the ONCE function.
- This non-volatile function is recalculated only when:
- A scheduled live data refresh runs.
- You select .
- You select
Related Functions
ONCE