Excel Math And Trigonometry Functions

This section will learn  how to use Excel’s Date And Time Functions such as: ABS, ACOS, ACOSH, Aggregate, ASIN, ASINH, etc.


ABS – returns the absolute value of a number


ACOS – returns the arccosine value of a number


ACOSH – returns the inverse hyperbolic cosine of a number


AGGREGATE – returns an aggregate in a list or database and ignore errors or hidden rows.it allow you to apply functions such as: SUM, COUNT, MAX, MIN, SMALL and etc.


ASIN – returns the arcsine value of a number


ASINH – returns the inverse hyperbolic sine of a number.


ATAN -returns the arctangent of a number.


ATAN2 – returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.


ATANH – returns the inverse hyperbolic tangent of a given number.


CEILING – returns a given number rounded up to the nearest multiple of a given number of significance.

CEILING.PRECISE – returns a given number rounded up to the nearest multiple of a given number of significance or returns a number that is rounded up to the nearest integer number.


COMBIN – returns the number of combinations for a given number of items.


COMBINA – returns the number of combinations for a given number of items and it includes repetitions.


COS – returns the cosine of a given angle.


COSH – returns the hyperbolic cosine of a given angle.


DEGREES – converts radians into degrees. And it will return a numeric value.


EVEN – rounds a given number up to the nearest even integer.


EXP –  returns e raised to the power of a number.


FACT – returns the factorial of a given number.


FLOOR – returns a number rounded down to the nearest multiple of significance.


INT – returns the integer portion of a given number.


LN – returns the natural logarithm of a given number.


LOG – returns the logarithm of a given number based on a supplied base.


LOG10 – returns the base-10 logarithm of a given number.


MDETERM – returns the matrix determinant of an array.


MINVERSE – returns the inverse matrix for a given matrix.


MMULT – returns the matrix product of two arrays.


MOD – returns the remainder of two numbers after division.


ODD – rounds a given number up to the nearest odd integer.


PI – returns the value of mathematical constant PI.


POWER – returns the result of a number raised to a given power.


PRODUCT – multiplies the numbers and returns the product.


RADIANS – converts degrees into radians in Excel.


RAND – returns a random real number that is greater than or equal to 0 and less than 1.


RANDBETWEEN – returns a random integer number that is between the numbers you specify.


ROMAN – converts an arabic numeral to roman and the format is Text for returned value.


ROUND – rounds a number to a specified number of digits.


ROUNDDOWN – round the number down to the specified number of digits.


ROUNDUP – rounds the number up to a specified number of decimal places.


SIGN – returns the sign of a number.


SIN – returns the hyperbolic tangent of a given number.


SINH – returns the hyperbolic sine of a number.


SQRT – returns the square root of a positive number.


SUBTOTAL – returns the subtotal of the numbers in a list or database


SIN – returns the sine of a given angle.


SUM – adds all numbers in a range of cells and returns the sum of these values.


SUMIF – sum the numbers in the range of cells that meet a single criteria that you specify.


SUMIFS – sum the numbers in the range of cells that meet a single or multiple criteria that you specify.


SUMPRODUCT – multiplies corresponding components in the given one or more arrays or ranges, and returns the sum of those products.


SUMSQ – returns the sum of squares of a given set of arguments.


SUMX2MY2 – returns the sum of the difference of squares between two supplied arrays.


SUMXMY2 – returns the sum of the squares of differences between corresponding values in two given arrays and then return the sum of the result.


SUMX2PY2 -returns the sum of the sum of squares of corresponding items in two supplied arrays.


TAN – returns the tangent of a given angle.


TANH -returns the hyperbolic tangent of a given number.


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


 

 

 

 

 

Leave a Reply