# Math and Trigonometry Functions

## Content

DsExcel.NET provides the following math and trigonometry functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [ABS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/abs) | This function calculates the absolute value of the specified value. |
| [ACOS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/acos) | This function calculates the arccosine, that is, the angle whose cosine is the specified value. |
| [ACOSH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/acosh) | This function calculates the inverse hyperbolic cosine of the specified value. |
| [ACOT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/acot) | This function calculates the inverse arccotangent of a number. |
| [ACOTH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/acoth) | This function calculates the inverse hyperbolic arccotangent of a number. |
| [AGGREGATE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/aggregate) | This function aggregate a list of numbers using a specified built-in function. |
| [ARABIC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/arabic) | This function converts a Roman numeral text to an Arabic numeral equivalent. |
| [ASIN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/asin) | This function calculates the arcsine, that is, the angle whose sine is the specified value. |
| [ASINH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/asinh) | This function calculates the inverse hyperbolic sine of a number. |
| [ATAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/atan) | This function calculates the arctangent, that is, the angle whose tangent is the specified value. |
| [ATAN2](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/atan2) | This function calculates the arctangent of the specified x- and y-coordinates. |
| [ATANH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/atanh) | This function calculates the inverse hyperbolic tangent of a number. |
| [BASE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/base) | This function converts a number into a text representation with the given radix (base). |
| [CEILING](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/ceiling) | This function rounds a number up to the nearest multiple of a specified value. |
| [CEILING.MATH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/ceilingmath) | This function rounds a number up to the nearest integer or the nearest multiple of significance. |
| [CEILING.PRECISE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/ceilingprecise) | This function rounds a number up to the nearest integer or the nearest multiple of a specified value. |
| [COMBIN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/combin) | This function calculates the number of possible combinations for a specified number of items. |
| [COMBINA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/combina) | This function calculates the number of possible combinations with repetitions for a specified number of items. |
| [COS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/cos) | This function returns the cosine of the specified angle. |
| [COSH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/cosh) | This function returns the hyperbolic cosine of the specified value. |
| [COT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/cot) | This function returns the cotangent of the specified angle. |
| [COTH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/coth) | This function returns the hyperbolic cotangent of the specified number. |
| [CSC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/csc) | This function returns the cosecant of the specified angle. |
| [CSCH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/csch) | This function returns the hyperbolic cosecant of the specified number. |
| [DECIMAL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/decimal) | This function converts a text representation of a number in a given base into a decimal number. |
| [DEGREES](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/degrees) | This function converts the specified value from radians to degrees. |
| [EVEN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/even) | This function rounds the specified value up to the nearest even integer. |
| [EXP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/exp) | This function returns e raised to the power of the specified value. |
| [FACT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/fact) | This function calculates the factorial of the specified number. |
| [FACTDOUBLE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/factdouble) | This function calculates the double factorial of the specified number. |
| [FLOOR.MATH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/floormath) | This function rounds a number down to the nearest integer or the nearest multiple of significance. |
| [FLOOR.PRECISE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/floorprecise) | This function rounds a number down to the nearest integer or the nearest multiple of a specified value. |
| [GCD](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/gcd) | This function returns the greatest common divisor of two numbers. |
| [INT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/int) | This function rounds a specified number down to the nearest integer. |
| [ISO.CEILING](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/isoceiling) | This function returns a number up to the nearest integer or the nearest multiple of significance, regardless of the sign of significance. |
| [LCM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/lcm) | This function returns the least common multiple of two numbers. |
| [LET](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/let) | This function assigns names to calculation results. |
| [LN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/ln) | This function returns the natural logarithm of the specified number. |
| [LOG](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/log) | This function returns the logarithm base Y of a number X. |
| [LOG10](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/log10) | This function returns the logarithm base 10 of the number given. |
| [MDETERM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/mdeterm) | This function returns the matrix determinant of an array. |
| [MINVERSE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/minverse) | This function returns the inverse matrix for the matrix stored in an array. |
| [MMULT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/mmult) | This function returns the matrix product for two arrays. |
| [MOD](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/mmult) | This function returns the remainder of a division operation. |
| [MROUND](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/mround) | This function returns a number rounded to the desired multiple. |
| [MULTINOMIAL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/multinomial) | This function calculates the ratio of the factorial of a sum of values to the product of factorials. |
| [MUNIT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/munit) | This function returns the unit matrix for the specified dimension. |
| [ODD](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/odd) | This function rounds the specified value up to the nearest odd integer. |
| [PERCENTOF](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/percentof) | This function returns the percentage that a subset makes up of a given data set. It is used in GROUPBY and PIVOTBY functions. |
| [PI](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/pi) | This function returns PI as 3.1415926536. |
| [POWER](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/power) | This function raises the specified number to the specified power. |
| [PRODUCT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/product) | This function multiplies all the arguments and returns the product. |
| [QUOTIENT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/quotient) | This function returns the integer portion of a division. Use this to ignore the remainder of a division. |
| [RADIANS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/radians) | This function converts the specified number from degrees to radians. |
| [RAND](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/rand) | This function returns an evenly distributed random number between 0 and 1. |
| [RANDARRAY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/randarray) | This function returns an array of random numeric values. |
| [RANDBETWEEN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/randbetween) | This function returns a random number between the numbers you specify. |
| [ROMAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/roman) | This function converts an Arabic numeral to a Roman numeral text equivalent. |
| [ROUND](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/round) | This function rounds the specified value to the nearest number, using the specified number of decimal places. |
| [ROUNDDOWN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/rounddown) | This function rounds the specified number down to the nearest number, using the specified number of decimal places. |
| [ROUNDUP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/roundup) | This function rounds the specified number up to the nearest number, using the specified number of decimal places. |
| [SEC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sec) | This function returns the secant of the specified angle. |
| [SECH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sech) | This function returns the hyperbolic secant of the specified value. |
| [SEQUENCE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sequence) | This function returns a list of sequential numbers in an array (in ascending order), such as 1, 2, 3, 4, and so on. |
| [SERIESSUM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/seriessum) | This function returns a sequence of numbers. |
| [SIGN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sign) | This function returns the sign of a number or expression. |
| [SIN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sin) | This function returns the sine of the specified angle. |
| [SINH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sinh) | This function returns the hyperbolic sine of the specified number. |
| [SQRT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sqrt) | This function returns the positive square root of the specified number. |
| [SQRTPI](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sqrtpi) | This function returns the positive square root of a multiple of pi (p). |
| [SUBTOTAL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/subtotal) | This function calculates a subtotal of a list of numbers using a specified built-in function. |
| [SUM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sum) | This function returns the sum of cells or range of cells. |
| [SUMIF](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sumif) | This function adds the cells using the given criteria. |
| [SUMIFS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sumifs) | This function adds the cells in a range using multiple criteria. |
| [SUMPRODUCT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sumproduct) | This function returns the sum of the products of cells. Multiplies corresponding components in the given arrays, and returns the sum of those products. |
| [SUMSQ](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sumsq) | This function returns the sum of the squares of the arguments. |
| [SUMX2MY2](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sumx2my2) | This function returns the sum of the difference of the squares of corresponding values in two arrays. |
| [SUMX2PY2](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sumxmy2) | This function returns the sum of squares of corresponding values in two arrays. |
| [SUMXMY2](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/sumxmy2) | This function returns the sum of the square of the differences of corresponding values in two arrays. |
| [TAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/tan) | This function returns the tangent of the specified angle. |
| [TANH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/tanh) | This function returns the hyperbolic tangent of the specified number. |
| [TRUNC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/math-and-trigonometric-functions/trunc) | This function removes the specified fractional part of the specified number. |