MATH AND TRIGONOMETRY FUNCTIONS

4ABS : Returns the absolute value of a number
4ACOS : Returns the arccosine of a number
4ACOSH : Returns the inverse hyperbolic cosine of a number
4ASIN : Returns the arcsine of a number
4ASINH : Returns the inverse hyperbolic sine of a number
4ATAN : Returns the arctangent of a number
4ATAN2 : Returns the arctangent from x- and y-coordinates
4ATANH : Returns the inverse hyperbolic tangent of a number
4CEILING : Rounds a number to the nearest integer or to the nearest multiple of significance
4COMBIN : Returns the number of combinations for a given number of objects
4COS : Returns the cosine of a number
4COSH : Returns the hyperbolic cosine of a number
4DEGREES : Converts radians to degrees
4EVEN : Rounds a number up to the nearest even integer
4EXP : Returns e raised to the power of a given number
4FACT : Returns the factorial of a number
4FACTDOUBLE : Returns the double factorial of a number
4FLOOR : Rounds a number down, toward zero
4GCD : Returns the greatest common divisor
4INT : Rounds a number down to the nearest integer
4LCM : Returns the least common multiple
4LN : Returns the natural logarithm of a number
4LOG : Returns the logarithm of a number to a specified base
4LOG10 : Returns the base-10 logarithm of a number
4MDETERM : Returns the matrix determinant of an array
4MINVERSE : Returns the matrix inverse of an array
4MMULT : Returns the matrix product of two arrays
4MOD : Returns the remainder from division
4MROUND : Returns a number rounded to the desired multiple
4MULTINOMIAL : Returns the multinomial of a set of numbers
4ODD : Rounds a number up to the nearest odd integer
4PI : Returns the value of pi
4POWER : Returns the result of a number raised to a power
4PRODUCT : Multiplies its arguments
4QUOTIENT : Returns the integer portion of a division
4RADIANS : Converts degrees to radians
4RAND : Returns a random number between 0 and 1
4RANDBETWEEN : Returns a random number between the numbers you specify
4ROMAN : Converts an arabic numeral to roman, as text
4ROUND : Rounds a number to a specified number of digits
4ROUNDDOWN : Rounds a number down, toward zero
4ROUNDUP : Rounds a number up, away from zero
4SERIESSUM : Returns the sum of a power series based on the formula
4SIGN : Returns the sign of a number
4SIN : Returns the sine of the given angle
4SINH : Returns the hyperbolic sine of a number
4SQRT : Returns a positive square root
4SQRTPI : Returns the square root of (number * pi)
4SUBTOTAL : Returns a subtotal in a list or database
4SUM : Adds its arguments
4SUMIF : Adds the cells specified by a given criteria
4SUMPRODUCT : Returns the sum of the products of corresponding array components
4SUMSQ : Returns the sum of the squares of the arguments
4SUMX2MY2 : Returns the sum of the difference of squares of corresponding values in two arrays
4SUMX2PY2 : Returns the sum of the sum of squares of corresponding values in two arrays
4SUMXMY2 : Returns the sum of squares of differences of corresponding values in two arrays
4TAN : Returns the tangent of a number
4TANH : Returns the hyperbolic tangent of a number
4TRUNC : Truncates a number to an integer