Math & Trigonometry

Built-in functions › Spreadsheet formulas › Math & Trigonometry

39 functions in this category.

Math & Trigonometry

Function	What it does
arabic	Convert a Roman numeral to an Arabic number.
base	Convert an integer to a string in a specified radix.
ceiling	Round up to a multiple of significance.
combin	Number of unordered selections (combinations) of k from n.
combina	Combinations with repetition allowed.
decimal	Convert a numeric string in any radix to a decimal number.
degrees	Convert radians to degrees.
even	Round up to the nearest even integer.
fact	Factorial.
factdouble	Double factorial.
gcd	Greatest common divisor.
int	Round down to the nearest integer.
lcm	Least common multiple.
ln	Natural logarithm (base e).
mmult	Matrix multiplication of two arrays.
mround	Round to the nearest multiple of a given value.
multinomial	Multinomial coefficient.
munit	Unit (identity) matrix.
odd	Round up to the nearest odd integer.
product	Product of all numeric arguments.
quotient	Integer portion of a division.
radians	Convert degrees to radians.
randarray	Array of uniform random values.
randbetween	Uniform random integer in a range.
roman	Convert an Arabic number to a Roman numeral.
rounddown	Round toward zero with specified precision.
roundup	Round away from zero with specified precision.
sequence	Generate a sequence of evenly-spaced numbers.
seriessum	Sum of a power series.
sqrtpi	Square root of number * pi.
subtotal	Aggregate over visible cells using a function code.
sumif	Sum cells in a range that meet a criterion.
sumifs	Sum cells meeting multiple criteria.
sumproduct	Sum of element-wise products of arrays.
sumsq	Sum of squares.
sumx2my2	Sum of (x² − y²) over paired arrays.
sumx2py2	Sum of (x² + y²) over paired arrays.
sumxmy2	Sum of squared differences between paired arrays.
trunc	Truncate toward zero.