Mathematics is an inevitable part of any decision making . Microsoft Excel categorically provide the set of functions to handle mathematical problems . There is separate category of Math & Trig functions dealing into providing support for mathematical and trigonometric challenges . Mathematical formulas in excel are used to perform various arithmetic operations like adding the values in a range of cells , finding an average of selected cells . The most commonly used mathematical functions in excel are Average , Int , Round , Mod , Rand etc.
MATH & TRIG. FUNCTIONS
There are total 84 functions in MS Excel . These are function are given below :
ABS : Returns the absolute value of a number , a number without it's sign.
ACOS : Returns the arccosine of a number , in radians in the range 0 to Pi . The arccosine is the angle whose cosine is number .
ACOSH : Returns the inverse hyperbolic cosine of a number .
ACOT : Returns the arccotangent of a number , in radians in the range 0 to Pi .
ACOTH : Returns the inverse hyperbolic cotangent of a number .
AGGREGATE : This function has multiple arguments lists . Please select one of them Arguments function_num,options,array,k. and function_num,options,ref1,.....
ARABIC : Converts a Roman numeral to Arabic .
ASIN : Returns the arcsine of a number in radians, in the range -Pi/2 to Pi /2 .
ASINH : Returns the inverse hyperbolic sine of a number .
ATAN : Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2 .
ATAN2 : Returns the arctangent of the specified x- and y- coordinates, in radians between -Pi and Pi, excluding -Pi .
ATANH : Returns the inverse hyperbolic tangent of a number .
BASE : Converts a number into a text representation with the given radix (base) .
CEILING.MATH : Rounds a number up, to the nearest integer or to the nearest multiple of significance .
COMBIN : Returns the number of combinations for a given number of items .
COMBINA : Returns the number of combinations with repetitions for a given number of items .
COS : Returns the cosine of an angle .
COSH : Returns the hyperbolic cosine of a number .
COT : Returns the cotangent of an angle .
COTH : Returns the hyperbolic cotangent of a number .
CSC : Returns the cosecant of an angle .
CSCH : Returns the hyperbolic cosecant of an angle .
DECIMAL : Converts a text representation of a number in a given base into a decimal number .
DEGREES : Converts radians to degree .
EVEN : Rounds a positive number up and negative number down to the nearest even integer .
EXP : Returns e raised to the power of a given number .
FACT : Returns the factorial number, equal, to 1*2*3*.....* Number .
FACTDOUBLE : Returns the double factorial of a number .
FLOOR.MATH : Rounds a number down, to the nearest integer or to the nearest multiple of significance .
GCD : Returns the greatest common divisor .
INT : Rounds a number down to the nearest integer .
LCM : Returns the least common multiple .
LN : Returns the natural logarithm of a number .
LOG : Returns the logarithm of a number to the base you specify .
LOG10 : Returns the base-10 logarithm of a number .
MDETERM : Returns the matrix determinant of an array .
MINVERSE : Returns the inverse matrix for the matrix stored in an array .
MMULT : Returns the matrix product of two arrays , an array with the same number of rows as array1 and columns as array2 .
MOD : Returns the remainder after a number is divided by a divisor .
MROUND : Returns a number rounded to the desired multiple .
MULTINOMIAL : Returns the multinational of a set of numbers .
MUNIT : Returns the unit matrix for the specified dimension .
ODD : Rounds a positive number up and negative number down to the nearest odd integer .
PI : Returns the value of Pi , 3.14159265358979 , accurate to 15 digits .
POWER : Returns the result of a number raised to a power .
PRODUCT : Multiplies all the numbers given as arguments .
QUOTIENT : Returns the integer portion of a division .
RADIANS : Converts degrees to radians .
RAND : Returns a random number greater than or equal to 0 and less than 1 , evenly distributed ( Changes on recalculation ) .
RANDBETWEEN : Returns a random number between the numbers you specify .
ROMAN : Converts an Arabic numeral to Roman , as text .
ROUND : Rounds a number to a specified number of digits .
ROUNDDOWN : Rounds a number down , toward zero .
ROUNDUP : Rounds a number up , away from zero .
SEC : Returns the secant of an angle .
SECH : Returns the hyperbolic secant of an angle .
SERIESSUM : Returns the sum of a power series based on the formula .
SIGN : Returns the sign of a number : 1 if the number is positive , zero if the number is zero , or -1 if the number is negative .
SIN : Returns the sign of an angle .
SINH : Returns the hyperbolic sine of a number .
SQRT : Returns the square root of a number .
SQRTPI : Returns the square root of ( number * Pi ) .
SUBTOTAL : Returns a subtotal in a list or database .
SUM : Adds all the numbers in a range of cells .
SUMIF : Adds the cells specified by a given condition or criteria .
SUMIFS : Adds the cells specified by a given set of conditions or criteria .
SUMPRODUCT : Returns the sum of the products of corresponding ranges or arrays .
SUMSQ : Returns the sum of the squares of the arguments . The arguments can be numbers , arrays , names , or references to cells that contain numbers .
SUMX2MY2 : Sums the differences between the squares of two corresponding ranges or arrays .
SUMX2PY2 : Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays .
SUMXMY2 : Sums the squares of the differences in two corresponding ranges or arrays .
TAN : Returns the tangent of an angle .
TANH : Returns the hyperbolic tangent of a number .
TRUNC : Truncates a number to an integer by removing the decimal , or fractional , part of the number .
Visit our blogs to know more about excel formulas & functions
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png&description=MATHEMATICAL & TRIGONOMETRIC FUNCTIONS IN MS EXCEL ){kind=link}
0 Comments