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.


x
How to Select Every Other Row in Excel

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.


 

 

 

 

 

Related Posts

Converting Week Number to Date
convert week to date4

This post will guide you how to convert a week number to a date with a formula in Excel. How do I calculate a date from a week number and a year with formula in Excel. Or how to get ...

Excel Vlookup From Another Workbook
vlookup from another worksheet

This post will guide you how to lookup value from another workbook in Excel. How do I use VLOOKUP function across multiple workbooks in Excel. How to vlookup a value from another workbook with a formula in Excel. Excel Vlookup ...

Excel DVARP Function
excel dvarp examples1

This post will guide you how to use Excel DVARP function with syntax and examples in Microsoft excel. Description The Excel DVARP Function will get the variance of a population based on the entire population of numbers in a column ...

Excel DVAR Function
excel dvar examples1

This post will guide you how to use Excel DVAR function with syntax and examples in Microsoft excel. Description The Excel DVAR Function will get the variance of a population based on a sample of numbers in a column in ...

Excel DSUM Function
excel dsum examples1

This post will guide you how to use Excel DSUM function with syntax and examples in Microsoft excel. Description The Excel DSUM Function will add the numbers in a column or database that meets a given criteria. And so you ...

Excel DSTDEVP Function
excel dstdevp examples1

This post will guide you how to use Excel DSTDEVP function with syntax and examples in Microsoft excel. Description The Excel DSTDEVP returns the standard deviation of a population based on the entire population of numbers in a column or ...

Excel DSTDEV Function
excel dstdev examples1

This post will guide you how to use Excel DSTDEV function with syntax and examples in Microsoft excel. Description The Excel DSTDEV returns the standard deviation of a population based on a sample of numbers in a column or database ...

Excel DMIN Function
excel dmin function example1

This post will guide you how to use Excel DMIN function with syntax and examples in Microsoft excel. Description The Excel DMIN returns the minimum value from a database or a column of a list that matches the specified conditions. ...

Excel DPRODUCT Function
excel dproduct examples1

This post will guide you how to use Excel DPRODUCT function with syntax and examples in Microsoft excel. Description The Excel DPRODUCT returns the product of values from a set of records that match criteria that you specify. The DPRODUCT ...

Excel XIRR Function
excel xirr examples1

This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. ...

Sidebar