▪RANDOM: Returns a random number greater or equal to 0 and less than 1 (modifies when it is recalculated) distributed evenly.
▪RANDOM BETWEEN: Returns a decimal random number between the numbers you specify, that is, within <lower>, <upper> interval.
Syntax:
|
RANDOMBETWEEN(<lower>;<upper>)
|
▪ROUND(<Number>): Rounds a <Number> to the nearest integer.
▪FACTORIAL: Returns the factorial of a <number>, that is, 1*2*3*...*number.
Syntax:
|
FACTORIAL(<number>)
|
▪ABSOLUTE: Returns the absolute value of a number, that is a number without a sign.
Syntax:
|
ABSOLUTE(<number>)
|
▪PRODUCT: Multiplies all the numbers given as arguments, that is, multiplies the values <number1>, <number2>, <number3>, ..., <numberN>. There are no fixed number of parameters.
Syntax:
|
PRODUCT(<number1>;<number2>;<number3>...<numberN>)
|
▪POWER: Raises the value <Number> to the power of <Exponent>.
Syntax:
|
POWER(<Number>;<Power>)
|
▪QUOTIENT: Returns the integer portion of a division of <Numerator> by <Denominator>.
Syntax:
|
QUOTIENT(<Numerator>;<Denominator>)
|
▪SQUARE ROOT: Returns a square root of a <number>.
Syntax:
|
SQUAREROOT(<number>)
|
▪MOD: Returns the integer remainder of the division of <Numerator> by <Denominator>.
Syntax:
|
MOD(<Numerator>;<Denominator>)
|
▪SUM: Adds the values <number1>, <number2>, <number3>, ..., <numberN>. There are no fixed number of parameters.
Syntax:
|
SUM(<number1>;<number2>;<number3>...<numberN>)
|
▪SUBTRACTION: Subtracts the values <number1>, <number2>, <number3>, ..., <numberN>. There are no fixed number of parameters.
Syntax:
|
SUBTRACTION(<number1>;<number2>;<number3>...<numberN>)
|
▪TRUNCATE: Rounds a <Number> down.
Syntax:
|
TRUNCATE(<number>)
|
▪HIGHEST: Returns the highest among the numbers given as arguments, that is, the highest value among <number1>, <number2>, <number3>, ..., <numberN>. There are no fixed number of parameters.
Syntax:
|
HIGHEST(<number1>;<number2>;<number3>...<numberN>)
|
▪LOWEST: Returns the lowest among the numbers given as arguments, that is, the lowest value among <number1>, <number2>, <number3>, ..., <numberN>. There are no fixed number of parameters.
Syntax:
|
LOWEST(<number1>;<number2>;<number3>...<numberN>)
|
|