Math functions

This type of function includes math, trigonometric, and logic functions.

As parameters of the function, you can pass numeric scalars, numeric functions, math constants, boolean scalars, boolean functions, or a column name. To pass a column cell, you can use the syntax ${columnName}. Other ways to use parameters: true , false, PI, E etc.

By default, real numbers in a column show only 2 digits after the integer part. You can change this behavior by setting the appropriate format for displaying the data in the column. To do this, click on the column heading and in the opened context menu select "Format" option.

Function List:

• Abs
• Acos
• Add
• And
• Asin
• Atan
• Atan2
• Avg
• Ceil
• Cos
• Div
• Eq
• Exp
• Fixed
• Floor
• FormatFloat
• Greater
• If
• Ln
• Log
• Log10
• Max
• Median
• Min
• Mod
• Mul
• Neg
• Not
• NotEq
• NotGreater
• NotSmaller
• Or
• Percentile
• Pow
• Qualifier
• RandBetween
• Rnd
• Round
• RoundFloat
• Sin
• Smaller
• Sqrt
• Sub
• Tan
• Xor

Abs(x)

Returns the absolute value of a number [x].

Abs(-10)    // 10

Acos(x)

Returns the arccosine of a number [x] as an angle expressed in radians in the interval 0..PI. x must be in the interval -1..1.

Acos(0.5)    // 1.047197580337524

Add(x, y)

Returns the sum of two numbers x and y.

Add(24.06, 100)    // 124.06

And(a, b)

Returns logical conjunction of boolean a and b.

And(true, false)        // false
And(5 == 5, 10 < 20)    // true

Asin(x)

Returns the arcsine of a number x as an angle expressed in radians in the interval -PI/2..PI/2. x must be in the interval -1..1.

Asin(0.5)    // 0.479425549507141

Atan(x)

Returns the arc tangent of a number x as an angle expressed in radians in the interval -PI/2..PI/2.

Atan(1)    // 0.785398185253143

Atan2(x, y)

Returns the angle in radians between the positive X-axis and the vector (y,x). The result is in the range -PI..PI. If y is positive, this is the same as Atan(x / y).

The result is negative when x is negative (including when x is -0.0). If x is equal to zero, the vector (y,x) is considered parallel to the X-axis, even if y is also equal to zero. The sign of y determines the direction of the vector along the X-axis.

Atan2(0, -0)    // 3.141592741012573

Avg([x1, x2, x3...])

Returns the average (arithmetic mean) of the numbers. Arguments are a set of numbers enclosed in square brackets.

Avg([-1, 3.5, 6.5])    // 3
Avg([1, 2, 3, 4])      // 2.5

Ceil(x)

Returns the least integer no smaller than x.

Ceil(3.5)     // 4
Ceil(-3.5)    // -3

Cos(x)

Returns the cosine of a number [x].

Cos(0)         // 1
Cos(PI / 3)    // 0.5

Div(x, y)

Returns the result of dividing x by y.

Div(7.5, 2)    // 3.75

Eq(x, y)

Returns true if x equal to y and false otherwise.

Eq(5, 5)           // true
Eq(true, false)    // false

Exp(x)

Returns the natural exponent (E) to the power x.

Exp(2)    // 7.389056205749512

Fixed(x, decimalPlaces)

Returns the rounded number x to the specified number of decimalPlaces.

Fixed(3.5, 2)   // 3.50
Fixed(-3.5, 0)  // -4

Floor(x)

Returns the greatest integer no greater than x.

Floor(3.5)     // 3
Floor(-3.5)    // -4

FormatFloat(x, format)

Returns the number x formatted according to the specified format.

FormatFloat(12345.12345, 'scientific')    // 1.23E4
FormatFloat(12345.12345, '#0.00')         // 12345.12

Greater(x, y)

Returns true if x is greater than y and false otherwise.

Greater(5, 5)    // false
Greater(5, 4)    // true

If(condition, ifTrue, ifFalse)

Returns ifTrue, if condition is true, or ifFalse otherwise.

If(true, "a", "b")                 // "a"
If(false, "a", "b")                // "b"
If(true, If(true, "a", "b"), "c")  // "a"
If(Eq(10, 50), 1, 0)               // 0

Ln(x)

Returns the natural logarithm of x.

Ln(1)    // 0
Ln(E)    // 1

Log(x, base)

Returns the logarithm of x expressed in the base specified by base.

Log(25, 5)    // 2

Log10(x)

Returns the 10-based logarithm of x.

Log10(100)    // 2

Max([x1, x2, x3 ...])

Returns the maximum value from the specified array of numbers.

Max([15, 21])    // 21

Median([x1, x2, x3...])

Calculates the median of the numbers. Arguments are a set of numbers enclosed in square brackets.

Median([0, 2, 5])       // 2
Median([0, 2, 5, 9])    // 2.5

Min([x1, x2, x3 ...])

Returns the minimum value from the specified array of numbers.

Min([15, 21])    // 15

Mod(x, y)

Returns the remainder of dividing x by y.

Mod(8, 3)    // 2

Mul(x, y)

Returns the product of x and y.

Mul(10, 1.5)    // 15

Neg(x)

Returns x with opposite sign.

Neg(-5)    // 5
Neg(12)    // -12

Not(a)

Returns logical negation of the a.

Not(true)     // false
Not(5 < 1)    // true

NotEq(x, y)

Returns false if x equal to y and true otherwise.

NotEq(5, 5)           // false
NotEq(true, false)    // true

NotGreater(x, y)

Returns true if x is less than or equal to y and false otherwise.

NotGreater(5, 5)    // true
NotGreater(6, 5)    // false

NotSmaller(x, y)

Returns true if x is greater than or equal to y and false otherwise.

NotSmaller(5, 5)    // true
NotSmaller(5, 6)    // false

Or(a, b)

Returns logical disjunction of boolean a and b.

Or(true, false)        // true
Or(5 == 6, 20 < 10)    // false

Percentile(nums, percentage)

Returns a value from nums below which a given percentage of values fall. percentage is in the range 0..1

Percentile(([1, 2, 3, 4], 0.25))     // 2
Percentile(([1, 2, 3, 4], 0.75))     // 4

Pow(x, exponent)

Returns x to the power of exponent.

Pow(2, 3)     // 8
Pow(2, -2)    // 0.25

Qualifier(x)

Extracts the qualifier from a qualified number x.

Qualifier(Qnum(1.5, "="))   // =
Qualifier(Qnum(1.5, "<"))   // <
Qualifier(Qnum(1.5, ">"))   // >

RandBetween(m, n)

Returns a random integer number within the range from m, inclusive, to n, exclusive.

RandBetween(5, 7)    // Randomly returns 5 or 6

Rnd(limit)

Returns a random integer number within the range from 0, inclusive, to n, exclusive. The absolute value is taken if the number is negative.

Rnd(2)    // Randomly returns 0 or 1

Round(x)

Returns the integer closest to x. Function rounds away from zero when there is no closest integer.

Round(3.4)     // 3
Round(3.5)     // 4
Round(-3.5)    // -4

RoundFloat(x, decimalPlaces)

Returns the number rounded up x to the number of decimal places specified by decimalPlaces.

decimalPlaces can be negative to round to even 10s, 100s, etc.

RoundFloat(PI, 2)      // 3.14
RoundFloat(25, -1)     // 30

Sin(x)

Returns the sine of the x.

Sin(0)         // 0
Sin(PI / 6)    // 0.5

Smaller(x, y)

Returns true if x is less than y and false otherwise.

Smaller(5, 5)    // false
Smaller(5, 6)    // true

Sqrt(x)

Returns the square root of the x.

Sqrt(6.25)    // 2.5

Sub(x, y)

Returns the difference between x and y.

Sub(10, 3)    // 7

Tan(x)

Returns the tangent of the x.

Tan(0)         // 0
Tan(PI / 6)    // 0.5

Xor(a, b)

Returns logical exclusive disjunction of boolean a and b.

Xor(true, false)        // true
Xor(5 == 5, 10 < 20)    // false