# 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.

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

Excel UNIQUE Function

The guide demonstrates how to use the UNIQUE function and dynamic arrays in Excel to create unique values. You'll learn how to use a basic formula to locate unique values inside a column or row, across many columns, and depending ...

Excel SORT Function

The excel sort function is one of the most useful new features in Excel. It is one of many functions that make advantage of Excel's new dynamic array calculation engine, which enables Excel to spill results from a single formula ...

Excel TRANSPOSE Function

Excel TRANSPOSE formula allows you to rotate (swap) values from rows to columns and vice versa in Excel. Its goal, as a component of the Excel lookup and reference functions, is to arrange data in the appropriate manner. To run ...

How to Calculate Retirement Date and Remaining Years refer to Birth Date in Excel

Every company has its own police about the retirement date for employees. Suppose employees will be retired from a certain age of 60, how can we calculate the retirement date for everyone base on their birthdays? Actually, there are several ...

Converting Week Number to Date

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

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

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

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

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

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 ...

Sidebar