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