English

# Math and trignometry Functions

Below listed are the various Math & Trigonometry Functions of Microsoft Excel 2007.

ABS function is used to find the absolute value of a number.

ACOS function returns the arccosine of the given number.

ACOSH function returns inverse hyperbolic cosine of the given number.

ASIN function returns the arcsine of the given number.

ASINH function returns inverse hyperbolic sine of the given number.

ATAN function returns the arctangent of the given number.

ATAN2 function returns the arctangent of the given x and y coordinates.

ATANH function returns inverse hyperbolic tangent of the given number.

CEILING function is used to round the numbers to the nearest multiple of the any number mentioned.

COMBIN function calculates the maximum number of combinations that can be formed with the given data.

COS function returns the cosine value of the given angle.

COSH function returns hyperbolic cosine of the given number.

EVEN function rounds up the given number to the nearest even number.

FACT function is used to find the factorial of the given number.

FLOOR function is used to round the given numbers down to the nearest multiple specified by the user.

GCD function is used to find the largest number which can be used to divide all the given numbers.

INT function rounds the given value down to the nearest integer (whole number).

LCM function is used to find the smallest number which can be divided by all the given numbers.

MMULT function is used to find the matrix product of two arrays.

MOD function is used to find the remainder in a division.

MROUND function rounds up or down the given number to the nearest multiple mentioned by the user.

ODD function rounds up the given number to the next highest odd number.

PI function is equal to the value of 3.14159265358979 and can be used in the calculations like area of a circle, etc.

POWER function raises the given number to the power of another.

PRODUCT function multiples the given set of numbers.

QUOTIENT function returns the quotient of a division.

RAND function generates a random number greater than or equal to 0 and less than 1.

RANDBETWEEN function generates random whole numbers between the two given numbers.

ROMAN function converts the given number to the corresponding Roman numeral.

ROUND function rounds the given numbers to the specified decimal places.

ROUNDDOWN function rounds the given numbers down to the specified decimal places.

ROUNDUP function rounds the given numbers up to the specified decimal places.

SIGN function checks if the given number is positive or negative.

SIN function returns the sine value of the given angle.

SINH function returns hyperbolic sine of the given number.

SUM function calculates and finds the total of given set of numbers.

SUMIF function calculates and finds the total of numbers, which match the given criteria.

SUMIFS function calculates and finds the total of numbers, which match the multiple criteria.

SUMPRODUCT function of arrays, multiplies the corresponding items and returns the sum of all the products.

SUMSQ function calculates and finds the sum of the squares of the given values.

SUMX2MY2 function, in given 2 arrays, finds the sum of the difference of the squares of the corresponding values.

SUMX2PY2 function, in given 2 arrays, finds the sum of the sum of the squares of the corresponding values.

SUMXMY2 function, in given 2 arrays, finds the sum of the squares of the differences of the corresponding values.

TAN function returns the tangent value of the given angle.

TANH function returns hyperbolic tangent of the given number.

TRUNC function truncates a number to an integer value by removing the fractional part of the number.