# math functions

Arithmetic, rounding, trigonometry and aggregation.

94 functions.

- [ABS](https://deepcalc.com/docs/functions/abs.md): returns absolute value of a number
- [ACOS](https://deepcalc.com/docs/functions/acos.md): returns arccosine of a number
- [ACOSH](https://deepcalc.com/docs/functions/acosh.md): returns inverse hyperbolic cosine
- [ACOT](https://deepcalc.com/docs/functions/acot.md): returns the arccotangent of a number
- [ACOTH](https://deepcalc.com/docs/functions/acoth.md): returns the inverse hyperbolic cotangent
- [ADD](https://deepcalc.com/docs/functions/add.md): adds two numbers: sheets exposes the + operator as a function
- [AGGREGATE](https://deepcalc.com/docs/functions/aggregate.md): aggregates a range with a chosen function, optionally ignoring error values
- [ARABIC](https://deepcalc.com/docs/functions/arabic.md): converts roman numeral to arabic number
- [ASIN](https://deepcalc.com/docs/functions/asin.md): returns arcsine of a number
- [ASINH](https://deepcalc.com/docs/functions/asinh.md): returns inverse hyperbolic sine
- [ATAN](https://deepcalc.com/docs/functions/atan.md): returns arctangent of a number
- [ATAN2](https://deepcalc.com/docs/functions/atan2.md): returns arctangent from x and y coordinates
- [ATANH](https://deepcalc.com/docs/functions/atanh.md): returns inverse hyperbolic tangent
- [AVERAGE](https://deepcalc.com/docs/functions/average.md): calculates arithmetic mean
- [BASE](https://deepcalc.com/docs/functions/base.md): converts number to text in given base
- [CEILING](https://deepcalc.com/docs/functions/ceiling.md): rounds up to the nearest multiple of significance
- [CEILING.MATH](https://deepcalc.com/docs/functions/ceiling-math.md): rounds up with optional significance and mode
- [CEILING.PRECISE](https://deepcalc.com/docs/functions/ceiling-precise.md): rounds up to the nearest multiple, sign-independent
- [CHOOSE](https://deepcalc.com/docs/functions/choose.md): chooses a value from a list by index
- [COLUMN](https://deepcalc.com/docs/functions/column.md): returns column number of a reference
- [COLUMNS](https://deepcalc.com/docs/functions/columns.md): returns number of columns in a reference
- [COMBIN](https://deepcalc.com/docs/functions/combin.md): number of combinations of n items taken k at a time
- [COMBINA](https://deepcalc.com/docs/functions/combina.md): combinations with repetitions
- [COS](https://deepcalc.com/docs/functions/cos.md): returns cosine of an angle
- [COSH](https://deepcalc.com/docs/functions/cosh.md): returns hyperbolic cosine
- [COT](https://deepcalc.com/docs/functions/cot.md): returns cotangent of an angle
- [COTH](https://deepcalc.com/docs/functions/coth.md): returns hyperbolic cotangent
- [CSC](https://deepcalc.com/docs/functions/csc.md): returns cosecant of an angle
- [CSCH](https://deepcalc.com/docs/functions/csch.md): returns hyperbolic cosecant
- [DECIMAL](https://deepcalc.com/docs/functions/decimal.md): converts text in given base to number
- [DEGREES](https://deepcalc.com/docs/functions/degrees.md): converts radians to degrees
- [DIVIDE](https://deepcalc.com/docs/functions/divide.md): divides the first number by the second
- [ECMA.CEILING](https://deepcalc.com/docs/functions/ecma-ceiling.md): rounds up to the nearest multiple of significance
- [EVEN](https://deepcalc.com/docs/functions/even.md): rounds up to the nearest even integer
- [EXP](https://deepcalc.com/docs/functions/exp.md): e raised to the power of a number
- [FACT](https://deepcalc.com/docs/functions/fact.md): factorial of a number
- [FACTDOUBLE](https://deepcalc.com/docs/functions/factdouble.md): returns double factorial of a number
- [FLOOR](https://deepcalc.com/docs/functions/floor.md): rounds down to the nearest multiple of significance
- [FLOOR.MATH](https://deepcalc.com/docs/functions/floor-math.md): rounds down with optional significance and mode
- [FLOOR.PRECISE](https://deepcalc.com/docs/functions/floor-precise.md): rounds down to the nearest multiple, sign-independent
- [GAMMA](https://deepcalc.com/docs/functions/gamma.md): returns the gamma function value
- [GCD](https://deepcalc.com/docs/functions/gcd.md): greatest common divisor
- [INT](https://deepcalc.com/docs/functions/int.md): rounds down to the nearest integer
- [ISO.CEILING](https://deepcalc.com/docs/functions/iso-ceiling.md): rounds up to the nearest multiple, sign-independent
- [LCM](https://deepcalc.com/docs/functions/lcm.md): least common multiple
- [LN](https://deepcalc.com/docs/functions/ln.md): natural logarithm of a number
- [LOG](https://deepcalc.com/docs/functions/log.md): logarithm to a given base
- [LOG10](https://deepcalc.com/docs/functions/log10.md): base-10 logarithm of a number
- [MAX](https://deepcalc.com/docs/functions/max.md): returns the largest value in a set
- [MDETERM](https://deepcalc.com/docs/functions/mdeterm.md): returns matrix determinant of an array
- [MIN](https://deepcalc.com/docs/functions/min.md): returns the smallest value in a set
- [MINUS](https://deepcalc.com/docs/functions/minus.md): subtracts the second number from the first
- [MINVERSE](https://deepcalc.com/docs/functions/minverse.md): returns matrix inverse of an array
- [MMULT](https://deepcalc.com/docs/functions/mmult.md): returns the matrix product of two arrays
- [MOD](https://deepcalc.com/docs/functions/mod.md): remainder after division
- [MROUND](https://deepcalc.com/docs/functions/mround.md): rounds to the nearest multiple
- [MULTINOMIAL](https://deepcalc.com/docs/functions/multinomial.md): returns the multinomial coefficient of a set of numbers
- [MULTIPLY](https://deepcalc.com/docs/functions/multiply.md): multiplies two numbers
- [MUNIT](https://deepcalc.com/docs/functions/munit.md): returns identity matrix of given size
- [ODD](https://deepcalc.com/docs/functions/odd.md): rounds up to the nearest odd integer
- [PI](https://deepcalc.com/docs/functions/pi.md): returns the value of pi
- [POW](https://deepcalc.com/docs/functions/pow.md): raises a number to a power
- [POWER](https://deepcalc.com/docs/functions/power.md): returns number raised to a power
- [PRODUCT](https://deepcalc.com/docs/functions/product.md): multiplies all numbers given as arguments
- [QUOTIENT](https://deepcalc.com/docs/functions/quotient.md): integer portion of a division
- [RADIANS](https://deepcalc.com/docs/functions/radians.md): converts degrees to radians
- [RAND](https://deepcalc.com/docs/functions/rand.md): returns a random number between 0 and 1
- [RANDBETWEEN](https://deepcalc.com/docs/functions/randbetween.md): returns random integer between two values
- [ROMAN](https://deepcalc.com/docs/functions/roman.md): converts arabic number to roman numeral
- [ROUND](https://deepcalc.com/docs/functions/round.md): rounds a number to specified digits
- [ROUNDDOWN](https://deepcalc.com/docs/functions/rounddown.md): rounds a number down toward zero
- [ROUNDUP](https://deepcalc.com/docs/functions/roundup.md): rounds a number up away from zero
- [SEC](https://deepcalc.com/docs/functions/sec.md): returns secant of an angle
- [SECH](https://deepcalc.com/docs/functions/sech.md): returns hyperbolic secant
- [SERIESSUM](https://deepcalc.com/docs/functions/seriessum.md): returns the sum of a power series
- [SIGN](https://deepcalc.com/docs/functions/sign.md): sign of a number as -1, 0 or 1
- [SIN](https://deepcalc.com/docs/functions/sin.md): returns sine of an angle
- [SINH](https://deepcalc.com/docs/functions/sinh.md): returns hyperbolic sine
- [SQRT](https://deepcalc.com/docs/functions/sqrt.md): returns square root of a number
- [SQRTPI](https://deepcalc.com/docs/functions/sqrtpi.md): returns square root of number times pi
- [SUM](https://deepcalc.com/docs/functions/sum.md): adds numbers together
- [SUMIF](https://deepcalc.com/docs/functions/sumif.md): sums cells that match a condition
- [SUMIFS](https://deepcalc.com/docs/functions/sumifs.md): sums cells that match multiple conditions
- [SUMPRODUCT](https://deepcalc.com/docs/functions/sumproduct.md): returns sum of products of array components
- [SUMSQ](https://deepcalc.com/docs/functions/sumsq.md): sum of the squares of the arguments
- [SUMX2MY2](https://deepcalc.com/docs/functions/sumx2my2.md): sum of the difference of squares of two ranges
- [SUMX2PY2](https://deepcalc.com/docs/functions/sumx2py2.md): sum of the sum of squares of two ranges
- [SUMXMY2](https://deepcalc.com/docs/functions/sumxmy2.md): sum of squared differences of two ranges
- [TAN](https://deepcalc.com/docs/functions/tan.md): returns tangent of an angle
- [TANH](https://deepcalc.com/docs/functions/tanh.md): returns hyperbolic tangent
- [TRUNC](https://deepcalc.com/docs/functions/trunc.md): truncates a number to a given precision
- [UMINUS](https://deepcalc.com/docs/functions/uminus.md): negates a number
- [UNARY_PERCENT](https://deepcalc.com/docs/functions/unary-percent.md): divides a number by 100
- [UPLUS](https://deepcalc.com/docs/functions/uplus.md): returns its argument unchanged

## navigate

- [function index](https://deepcalc.com/docs/functions.md)
- [error values](https://deepcalc.com/docs/errors.md) · [concepts](https://deepcalc.com/docs/concepts.md) · [limits](https://deepcalc.com/docs/limits.md)

source: https://deepcalc.com/docs/functions/math-functions