|
Function / Event |
Return Value |
Description |
Syntax |
|
Math |
|||
|
Abs |
Integer |
Accepts an integer number (x) input, and returns the modulus or non-negative value of the number. For example, the absolute value of -3 is 3. |
Abs <int Value> |
|
Add Decimals* |
Decimal |
Performs mathematical addition of two decimals. |
Add <Decimal> and <Decimal> |
|
Add Integers* |
Number |
Performs mathematical addition of two integers. |
Add <Integer> and <Integer> |
|
Average Decimals |
Decimal |
Averages a series of decimals. |
Average <List of Decimals> |
|
Average Integers |
Decimal |
Averages a series of integers. |
Average <List of Numbers> |
|
Ceiling |
Integer |
Accepts a real number (x) input, and returns the nearest integer that is greater than or equal to x. For example, ceiling value for input 2.5 is 3. |
Ceiling <Double Value> |
|
Cos |
Decimal |
Calculates the cosine of a specified decimal value. |
Cos <Decimal> |
|
Deviation |
Decimal |
Calculates the standard deviation of a series of decimal values. |
Deviation <List of Decimals> |
|
Divide Decimals |
Decimal |
Performs mathematical division of decimals. |
Divide <Decimal> By <Decimal> |
|
Divide Integers |
Decimal |
Performs mathematical division of integers. Use this function when division of number returns the decimal value. |
Divide <Integer> By <Integer> |
|
Divide Integers |
Number |
Performs mathematical division of integers. |
Divide <Integer> By <Integer> |
|
Floor |
Integer |
Accepts a real number (x) input, and returns the nearest integer that is lesser than or equal to x. For example, floor value for input 2.4 is 2. |
Floor a <double Value> |
|
Max Decimals |
Decimal |
Calculates the maximum numeric value as a series of decimals. |
Max <List of Decimals> |
|
Max Integers |
Number |
Calculates the maximum numeric value as a series of integers. |
Max <List of Numbers> |
|
Median |
Decimal |
Calculates the median of a series of decimal values. |
Median <List of Decimals> |
|
Min Decimals |
Decimal |
Calculates the minimum numeric value as a series of decimals. |
Min <List of Decimals> |
|
Min Integers |
Number |
Calculates the minimum numeric value as a series of integers. |
Min <List of Numbers> |
|
Multiply Decimals |
Decimal |
Performs mathematical multiplication of decimals. |
Multiply <List of Decimals> |
|
Multiply Integers |
Number |
Performs mathematical multiplication of integers. |
Multiply <List of Numbers> |
|
Power |
Decimal |
Raises a decimal value by a given decimal power value. |
Power of <Decimal> Raised By < Decimal Degree> |
|
Random |
Number |
Produces a random positive integer that is smaller than the specified maximum value. |
Random <Maximum Number> |
|
Remainder Of |
Number |
Calculates the remainder resulting from the division of a specified integer by another specified integer value. |
Remainder Of <Number> Divided By <Divisor> |
|
Round Decimals |
Decimal |
Rounds a decimal value to a specified precision. |
Rounds A <Decimal> To A <Specified> Precision |
|
Sin |
Decimal |
Calculates the sine of a specified decimal value. |
Sin <Decimal> |
|
Square Root |
Decimal |
Calculates the square root of a decimal value. |
Square Root Of <Decimal> |
|
Subtract Decimals |
Decimal |
Performs mathematical subtraction of two decimals. |
Subtract <List of Decimals> |
|
Subtract Integers |
Number |
Performs mathematical subtraction of two integers. |
Subtract <List Of Numbers> |
|
Sum Decimals |
Decimal |
Performs mathematical addition of decimals. |
Sum <List Of Decimals> |
|
Sum Integers |
Number |
Performs mathematical addition of integers. |
Sum <List Of Numbers> |
* Functions added in version 7.2.
