Explore more
Functions
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 abs( 5 ) = 5 abs( 5 ) = 5 abs( 0 ) = 0 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 ceil( 1 2 ) = 2 ceil ( 4 ) = 4 floor floor (number) returns the largest integer less than or equal to a specified number floor( 1 2 ) = 1 floor( 1 9 ) = 1 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 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 median( 3; 5; 7 ) = 5 median( 2; 3; 5; 8 ) = 4 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 round( 1 2 ) = 1 round( 1 5 ) = 2 round( 1 7 ) = 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 stdevp( 1; 2; 3; 4; 5) = 1 4142135623730951 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 stdevs( 1; 2; 3; 4; 5) = 1 5811388300841898 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 trunc( 3 789) = 3 trunc( 3 789; 2) = 3 78 trunc( 3 789; 2 ) = 3 7 trunc( 123 456; 2 ) = 100