Random Number

Syntax

Function:
  • RANDOM(length)
Parameters:
  • length =  a numeric value (Optional)
Outputs:
  • a random number or string
Description:
  • The RANDOM() function Generates a random number or string. Can be called with 0 or 1 parameter.
  • RANDOM() returns a decimal number between 0 and 1.0.
  • RANDOM(length)  returns random integer of given length.
Used:
in a Formula BuilderFormula Builder

 

Example
Result
Note
RANDOM( 1 ) 6
RANDOM( 3 ) 647
RANDOM( 5 ) 51286
 random dynamic
random
tanh(). atan(). imgurl(). Mathematical Functions. random(). Generate a Unique ID Code. Repeats. Choices Functions. sqrt(). userlastname(). Data Conversion. acos(). cos(). Excel Financial Functions. today(). Functions Table. userfirstname(). radians(). Contextual Functions. string().