• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Math & Trig Functions

Math & Trig Functions

ABS(number)Returns the absolute value of a number.
ACOS(number)Returns the arccosine of a number.
ACOSH(number)Returns the inverse hyperbolic cosine of a number.
ASIN(number)Returns the arcsine of a number.
ASINH(number)Returns the inverse hyperbolic sine of a number.
ATAN(number)Returns the arctangent of a number.
ATAN2(x_num,y_num)Returns the arctangent from x- and y-coordinates.
ATANH(number)Returns the inverse hyperbolic tangent of a number.
CEILING(number,significance)Rounds a number to the nearest whole number or to the nearest multiple of significance.
COMBIN(number,number_chosen)Returns the number of combinations for a given number of objects.
COS(number)Returns the cosine of a number.
COSH(number)Returns the hyperbolic cosine of a number.
DEGREES(angle)Converts radians to degrees.
EVEN(number)Rounds a number up to the nearest even whole number.
EXP(number)Returns e raised to the power of a given number.
FACT(number)Returns the factorial of a number.
FLOOR(number, significance)Rounds a number down, toward 0.
INT(number)Rounds a number down to the nearest whole number.
LN(number)Returns the natural logarithm of a number.
LOG(number,base)Returns the logarithm of a number to a specified base.
LOG10(number)Returns the base-10 logarithm of a number.
MDETERM(array)Returns the matrix determinant of an array.
MINVERSE(array)Returns the matrix inverse of an array.
MMULT(array1,array2)Returns the matrix product of two arrays.
MOD(number,divisor)Returns the remainder from division.
ODD(number)Rounds a number up to the nearest odd whole number.
PI( )Returns the value of pi.
POWER(number,power)Returns the result of a number raised to a power.
PRODUCT(number 1,number2,…)Multiplies its arguments.
RADIANS(angle)Converts degrees to radians.
RAND( )Returns a random number between 0 and 1.
ROMAN(number,form)Converts an Arabic numeral to a Roman numeral, as text.
ROUND(number,num_digits)Rounds a number to a specified number of digits.
ROUNDDOWN(number,num_digits)Rounds a number down, toward 0.
ROUNDUP(number,num_digits)Rounds a number up, away from 0.
SIGN(number)Returns the sign of a number.
SIN(number)Returns the sine of a number.
SINH(number)Returns the hyperbolic sine of a number.
SQRT(number)Returns a positive square root.
SUBTOTAL(function_num,ref1,…)Returns a subtotal in a list or database.
SUM(number1,number2,…)Adds its arguments.
SUMIF(range,criteria, sum_range)Adds the cells specified by a given criteria.
SUMPRODUCT(array1,array2,array3,…)Returns the sum of the products of corresponding array components.
SUMSQ(number1,number2,…)Returns the sum of the squares of its arguments.
SUMX2MY2(array_x,array_y)Returns the sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2(array_x,array_y)Returns the sum of the sum of squares of corresponding values in two arrays.
SUMXMY2(array_x,array_y)Returns the sum of squares of differences of corresponding values in two arrays.
TAN(number)Returns the tangent of a number.
TANH(number)Returns the hyperbolic tangent of a number.
TRUNC(number,num_digits)Truncates a number to a whole number.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint