Documentation/How Tos/Calc: Mathematical functions

List of Calc Mathematical functions

Trigonometric
COS	Returns the cosine of an angle.
SIN	Returns the sine of an angle.
TAN	Returns the tangent of an angle.
COT	Returns the cotangent of an angle.
ACOS	Returns the inverse cosine of a number.
ACOT	Returns the inverse cotangent of a number.
ASIN	Returns the inverse sine of a number.
ATAN	Returns the inverse tangent of a number.
ATAN2	Returns the inverse tangent for specified x and y coordinates.
DEGREES	Converts radians into degrees.
RADIANS	Converts degrees into radians.
PI	Returns the value of PI.
Hyperbolic
COSH	Returns the hyperbolic cosine of an angle.
SINH	Returns the hyperbolic sine of an angle.
TANH	Returns the hyperbolic tangent of an angle.
COTH	Returns the hyperbolic cotangent of a given number (angle).
ACOSH	Returns the inverse hyperbolic cosine of a number.
ACOTH	Returns the inverse hyperbolic cotangent of the given number.
ASINH	Returns the inverse hyperbolic sine of a number.
ATANH	Returns the inverse hyperbolic tangent of a number.
Rounding and remainders
TRUNC	Truncates a number by removing decimal places.
ROUND	Rounds a number to a certain precision.
ROUNDDOWN	Rounds a number down, toward zero, to a certain precision.
ROUNDUP	Rounds a number up, away from zero, to a certain precision.
CEILING	Returns a number rounded up to a multiple of another number.
FLOOR	Rounds a number down to the nearest multiple of another number.
EVEN	Rounds a number to the next even integer away from zero.
ODD	Rounds a number up to the next highest odd integer.
MROUND	Returns a number rounded to the nearest multiple of another number*.
INT	Rounds a number down to the nearest integer.
QUOTIENT	Returns the integer result of a division operation*.
MOD	Returns the remainder when one integer is divided by another.
Logarithm / powers
EXP	Returns e raised to the power of a number.
POWER	Returns a number raised to a power.
LOG	Returns the natural logarithm of a number.
LN	Returns the logarithm of a number to the specified base.
LOG10	Returns the base-10 logarithm of a number.
Miscellaneous
ABS	Returns the absolute value of a number.
COMBIN	Returns the number of combinations of a subset of items.
COMBINA	Returns the number of ordered combinations of a subset of items.
CONVERT	Converts between legacy European currencies and Euros.
COUNTBLANK	Returns the number of empty cells.
COUNTIF	Counts the number of cells in a range that meet a specified condition.
FACT	Returns the factorial of a number, n!.
FACTDOUBLE	Returns the double factorial of a number, n!!.
GCD	Returns the greatest common divisor of two or more integers.
GCD_ADD	Returns the greatest common divisor of a list of numbers*.
ISEVEN	Returns TRUE if the value is an even number.
ISODD	Returns TRUE if the value is an odd number.
LCM	Returns the least common multiple of one or more integers.
LCM_ADD	Returns the lowest common multiple of a list of numbers*.
MULTINOMIAL	Returns the factorial of the sum divided by the product of the factorials*.
PRODUCT	Multiplies all the numbers given as arguments and returns the product.
RAND	Returns a random number between 0 and 1.
RANDBETWEEN	Returns an integer random number in a specified range*.
SERIESSUM	Sums the first terms of a power series*.
SIGN	Returns the sign of a number.
SQRT	Returns the positive square root of a number.
SQRTPI	Returns the square root of (PI times a number)*.
SUBTOTAL	Returns SUM, AVERAGE, STDDEV, etc. results for filtered data.
SUM	Sums the contents of cells.
SUMIF	Conditionally sums the contents of cells in a range.
SUMSQ	Returns the sum of the squares of numbers.

See also

Functions listed by category