Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42
Math and trignometry Functions in Microsoft Excel 2007 | Video Tutorial

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.

Learn MS Excel


Ask Questions

Ask Question