• 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