English

# Math and trignometry Functions

Below listed are the various Math & Trigonometry Functions of Microsoft Excel 2007. Abs():

ABS function is used to find the absolute value of a number. Acos():

ACOS function returns the arccosine of the given number. Acosh():

ACOSH function returns inverse hyperbolic cosine of the given number. Asin():

ASIN function returns the arcsine of the given number. Asinh():

ASINH function returns inverse hyperbolic sine of the given number. Atan():

ATAN function returns the arctangent of the given number. Atan2():

ATAN2 function returns the arctangent of the given x and y coordinates. Atanh():

ATANH function returns inverse hyperbolic tangent of the given number. Ceiling():

CEILING function is used to round the numbers to the nearest multiple of the any number mentioned. Combin():

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

COS function returns the cosine value of the given angle. Cosh():

COSH function returns hyperbolic cosine of the given number. Even():

EVEN function rounds up the given number to the nearest even number. Fact():

FACT function is used to find the factorial of the given number. Floor():

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

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

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

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

MMULT function is used to find the matrix product of two arrays. Mod():

MOD function is used to find the remainder in a division. Mround():

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

ODD function rounds up the given number to the next highest odd number. Pi():

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

POWER function raises the given number to the power of another. Product():

PRODUCT function multiples the given set of numbers. Quotient():

QUOTIENT function returns the quotient of a division. Rand():

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

RANDBETWEEN function generates random whole numbers between the two given numbers. Roman():

ROMAN function converts the given number to the corresponding Roman numeral. Round():

ROUND function rounds the given numbers to the specified decimal places. Rounddown():

ROUNDDOWN function rounds the given numbers down to the specified decimal places. Roundup():

ROUNDUP function rounds the given numbers up to the specified decimal places. Sign():

SIGN function checks if the given number is positive or negative. Sin():

SIN function returns the sine value of the given angle. Sinh():

SINH function returns hyperbolic sine of the given number. Sum():

SUM function calculates and finds the total of given set of numbers. Sumif():

SUMIF function calculates and finds the total of numbers, which match the given criteria. Sumifs():

SUMIFS function calculates and finds the total of numbers, which match the multiple criteria. Sumproduct():

SUMPRODUCT function of arrays, multiplies the corresponding items and returns the sum of all the products. Sumsq():

SUMSQ function calculates and finds the sum of the squares of the given values. Sumx2my2():

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

SUMX2PY2 function, in given 2 arrays, finds the sum of the sum of the squares of the corresponding values. Sumxmy2():

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

TAN function returns the tangent value of the given angle. Tanh():

TANH function returns hyperbolic tangent of the given number. Trunc():

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