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
degrees(). cosh(). useremail(). int(). orgname(). counter(). Functions Table. now(). userfirstname(). pi(). number(). random(). Excel Financial Functions. Create a Formula. Logic. string(). Functions. utcnow(). acos(). Template Functions.