Math functions

21min
Use a math function to apply mathematical operations to data. For example, math functions let you get an average of an array, round a value up or down, or change the format of a number (1 000 000 to 1,000,000 or 1.000.000). Below is a list of supported math functions and a brief description of each one.
abs 
abs (number)
Returns the absolute value of an integer.
Text
abs( -5 ) = 5
abs( -5 ) = 5
﻿
Text
abs( 5 ) = 5
abs( 5 ) = 5
﻿
Text
abs( 0 ) = 0
abs( 0 ) = 0
﻿
Text
abs( -3.7 ) = 3.7
abs( -3.7 ) = 3.7
﻿
average
average ([array of values]) average(value1; [value2], ...)
Returns the average value of the numeric values in a specific array, or the average value of numerical values entered individually.
ceil
ceil (number)
Returns the smallest integer greater than or equal to a specified number.
Text
ceil( 1.2 ) = 2
ceil( 1.2 ) = 2
﻿
Text
ceil ( 4 ) = 4
ceil ( 4 ) = 4
﻿
floor
floor (number)
Returns the largest integer less than or equal to a specified number.
Text
floor( 1.2 ) = 1
floor( 1.2 ) = 1
﻿
Text
floor( 1.9 ) = 1
floor( 1.9 ) = 1
﻿
Text
floor( 4 ) = 4
floor( 4 ) = 4
﻿
formatNumber
formatNumber (number; decimalPOINTS; [decimalSeparator]; [thousandsSeparator])
Returns a number in the requested format. Decimal point is `,` by default, Thousands separator is `.` by default.
Text
formatNumber( 123456789 ; 3 ; , ; . ) = 123.456.789,000
formatNumber( 123456789 ; 3 ; , ; . ) = 123.456.789,000
﻿
max
max ([array of values]), max(value1;value2; ...)
Returns the largest number in a specified array, or the largest number among numbers entered individually.
median
median ([array of values])
Returns the median of the values in a specified array, or the median of numbers entered individually.
Text
median( 3; 5; 7 ) = 5
median( 3; 5; 7 ) = 5
﻿
Text
median( 2; 3; 5; 8 ) = 4
median( 2; 3; 5; 8 ) = 4
﻿
Text
median( 2.5; 3.5; 2; 4.5; 1 ) = 2.5
median( 2.5; 3.5; 2; 4.5; 1 ) = 2.5
﻿
min
min ([array of values]), min(value1;value2; ...)
Returns the smallest number in a specified array, or the smallest number among numbers entered individually.
parseNumber
parseNumber (number; decimal separator)
Parses a string with a number and returns the number.
Example: parseNumber( 1 756,456 ; , )
round
round (number)
Rounds a numeric value to the nearest integer.
Text
round( 1.2 ) = 1
round( 1.2 ) = 1
﻿
Text
round( 1.5 ) = 2
round( 1.5 ) = 2
﻿
Text
round( 1.7 ) = 2
round( 1.7 ) = 2
﻿
Text
round( 2 ) = 2
round( 2 ) = 2
﻿
stdevP
stdevP ([array of values])
Returns the standard deviation of a specified array of population values, or the standard deviation of numbers entered individually.
Text
stdevP( 1; 2; 3; 4; 5) = 1.4142135623730951
stdevP( 1; 2; 3; 4; 5) = 1.4142135623730951
﻿
Text
stdevP( {{array}} )
stdevP( {{array}} )
﻿
stdevS
stdevS ([array of values])
Returns the standard deviation of a specified array of sample values, or the standard deviation of numbers entered individually.
Text
stdevS( 1; 2; 3; 4; 5) = 1.5811388300841898
stdevS( 1; 2; 3; 4; 5) = 1.5811388300841898
﻿
Text
stdevS( {{array}} )
stdevS( {{array}} )
﻿
sum
sum ([array of values]), sum(value1;value2; ...)
Returns the sum of the values in a specified array, or the sum of numbers entered individually.
trunc
trunc (number)
Truncates a number to an integer by removing the fractional part of the number.
Text
trunc( 3.789) = 3
trunc( 3.789) = 3
﻿
Text
trunc( 3.789; 2) = 3.78
trunc( 3.789; 2) = 3.78
﻿
Text
trunc( -3.789; 2 ) = -3.7
trunc( -3.789; 2 ) = -3.7
﻿
Text
trunc( 123.456; -2 ) = 100
trunc( 123.456; -2 ) = 100
﻿
﻿
General functions
Math variables