Math

abs description returns the absolute value of a value example abs(number) acos description returns the inverse cosine example acos(number) acosh description returns the inverse hyperbolic cosine example acosh(number) asin description returns the inverse sine example asin(number) asinh description returns the inverse hyperbolic sine example asinh(number) atan description returns the inverse tangent example atan(number) atan2 description returns the inverse tangent example atan2(x num,y num) atanh description returns the inverse hyperbolic tangent example atanh(number) avg description returns the arithmetic mean of the listed arguments example avg(number1, number2, ) ceiling description returns the rounded up value example ceiling(number, significance) combin description returns the number of combinations example combin(number, number chosen) cos description returns the cosine example cos(number) cosh description returns the hyperbolic cosine example cosh(number) degrees description returns the degrees represented by the given radians example degrees(angle) even description returns the number rounded up to the nearest even integer example even(number) exp description returns the value of e raised to the given argument example exp(number) fact description returns the factorial of the given value example fact(number) factdouble description returns the doublefactorial of the given value example factdouble(number) fixed description rounds off to a specified number of decimal places and returns the value in text format example fixed (number, decimal places, no commas) floor description returns the value rounded down to the nearest value example floor(number, significance) gcd description returns the greatest common divisor of two or more given values example gcd(number1, numer2, ) int description returns the value rounded down to nearest integer example int(number) lcm description returns the least common multiple of two or more given values example lcm(number1, number2, ) ln description returns the natural logarithm of the value example ln(number) log description returns the logarithm to a given base example log(number, base) log10 description returns the logarithm base 10 example log10(number) mod description returns the remainder after a division example mod(number, divisor) mround description rounds a given number up or down to the nearest multiple of a given number example mround(number, multiple) multinomial description returns the ratio of the factorial of a sum of values to the product of factorials example multinomial(number1, (number2), ) n description converts the given value into a numeric value example n(value) odd description returns the value to the nearest odd integer example odd(number) pi description returns the pi example pi( ) pow description returns the value of one number raised to another number example pow(number, power) power description returns the result of a number raised to a power example power(number, power) product description returns the product of the listed values example product(number1, number2, ) quotient description returns the integer portion of a division between two given numbers example quotient(numerator, denominator) radians description returns the radians from given degrees example radians(angle) rand description returns a random value example rand( ) randbetween description returns a random number that is between the given ranges example randbetween(start num, end num) roman description converts an arabic number to a roman numeral example roman(number, (form)) round description returns the number to a specified number of digits example round(number, num digits) rounddown description returns the number rounded down example rounddown(number, num digits) roundup description returns the number rounded up example roundup(number, num digits) sign description returns the sign of the number example sign(number) sin description returns the sine of the given angle example sin(number) sinh description returns the hyperbolic sine example sinh(value) sqrt description returns the square root of a number example sqrt(number) sqrtpi description returns the square root of a given number multiplied by pi example sqrtpi(number) subtotal description returns a subtotal in a list example subtotal(function number, ref1, (ref2), ) sum description returns the sum of the listed values example sum(number1, number2, number n) sumif description returns the conditional sum of the listed values example sumif(range, criteria, sum range) sumifs description sums the values in a given array that satisfy a set of given criteria example sumifs(sum range, criteria range1, criteria1, \[criteria range2, criteria2], ) sumproduct description returns the sum of the products example sumproduct(array1, array2, array3, ) sumsq description returns the sum of the squares example sumsq(number1, number2, ) sumx2my2 description returns the differences of the squares example sumx2my2(array x, array y) sumx2py2 description returns the sum of the squares example sumx2py2(array x, array y) sumxmy2 description returns the squares of the differences example sumxmy2(array1, array2) tan description returns the tangent example tan(number) tanh description returns the hyperbolic tangent example tanh(number) trunc description returns the number without a fractional part example trunc(number, num digits)