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
Generate a Unique ID Code. now(). degrees(). cos(). tan(). Create a Formula. string(). userexternalid(). sqrt(). imgurl(). Excel Financial Functions. Logic. Template Functions. format-num(). logarithm(). userlastname(). Data Conversion. Location Functions. acos(). date().