Maths and trigonometry functions (reference)

accounting administration books business

  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

This blog post presents you with a list of all Maths and trigonometry functions. To obtain in-depth details about a function, select its name in the first column.

Note: Version markers represent the Excel version when a function was launched. These functions are absent from earlier versions. For example, a version marker of 2013 signifies that this function is available in Excel 2013 and all further versions.

FunctionDescription
ABS functionYields the absolute value of a number.
ACOS functionGathers the arccosine of a number.
ACOSH functionObtains the inverse hyperbolic cosine of a number.
ACOT function
Excel 2013
Retrieves the arccotangent of a number.
ACOTH function
Excel 2013
Gets the hyperbolic arccotangent of a number.
AGGREGATE functionObtains the aggregate in a list or database.
ARABIC function
Excel 2013
Converts a Roman number to Arabic, as a number.
ASIN functionBrings back the arcsine of a number.
ASINH functionGathers the inverse hyperbolic sine of a number.
ATAN functionGets the arctangent of a number.
ATAN2 functionYields the arctangent from x- and y-coordinates.
ATANH functionRetrieves the inverse hyperbolic tangent of a number.
BASE function
Excel 2013
Converts a number into a text representation with the specified radix (base).
CEILING functionRounds a number to the nearest integer or to the nearest multiple of significance.
CEILING.MATH function
Excel 2013
Rounds a number up, to the nearest integer or to the nearest multiple of significance.
CEILING.PRECISE functionRounds a number the nearest integer or to the nearest multiple of significance. The number is always rounded up irrespective of the number’s sign.
COMBIN functionCaptures the number of combinations for a defined number of objects.
COMBINA function
Excel 2013
Yields the number of combinations with repetitions for a selected number of items.
COS functionBrings back the cosine of a number.
COSH functionRetrieves the hyperbolic cosine of a number.
COT function
Excel 2013
Gathers the cotangent of an angle.
COTH function
Excel 2013
Gets the hyperbolic cotangent of a number.
CSC function
Excel 2013
Obtains the cosecant of an angle.
CSCH function
Excel 2013
Brings back the hyperbolic cosecant of an angle.
DECIMAL function
Excel 2013
Converts a text representation of a number in a given base into a decimal number.
DEGREES functionConverts radians to degrees.
EVEN functionRounds a number up to the nearest even integer.
EXP functionGathers e raised to the power of a given number.
FACT functionObtains the factorial of a number.
FACTDOUBLE functionRetrieves the double factorial of a number.
FLOOR functionRounds a number down, toward zero.
FLOOR.MATH function
Excel 2013
Rounds a number down, to the nearest integer or to the nearest multiple of significance.
FLOOR.PRECISE functionRounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.
GCD functionGets the greatest common divisor.
INT functionRounds a number down to the nearest integer.
ISO.CEILING function
Excel 2013
Brings back a number that is rounded up to the nearest integer or to the nearest multiple of significance.
LCM functionSecures the least common multiple.
LN functionObtains the natural logarithm of a number.
LOG functionGets the logarithm of a number to a specified base.
LOG10 functionYields the base-10 logarithm of a number.
MDETERM functionReturns the matrix determinant of an array.
MINVERSE functionReturns the matrix inverse of an array.
MMULT functionReturns the matrix product of two arrays.
MOD functionReturns the remainder from division.
MROUND functionReturns a number rounded to the desired multiple.
MULTINOMIAL functionReturns the multinomial of a set of numbers.
MUNIT function
Excel 2013
Returns the unit matrix or the specified dimension.
ODD functionRounds a number up to the nearest odd integer.
PI functionReturns the value of pi.
POWER functionReturns the result of a number raised to a power.
PRODUCT functionMultiplies its arguments.
QUOTIENT functionReturns the integer portion of a division.
RADIANS functionConverts degrees to radians.
RAND functionReturns a random number between 0 and 1.
RANDARRAY functionOffice 365 buttonReturns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.
RANDBETWEEN functionReturns a random number between the numbers you specify.
ROMAN functionConverts an Arabic numeral to Roman, as text.
ROUND functionRounds a number to a specified number of digits.
ROUNDDOWN functionRounds a number down, toward zero.
ROUNDUP functionRounds a number up, away from zero.
SEC function
Excel 2013
Returns the secant of an angle.
SECH function
Excel 2013
Returns the hyperbolic secant of an angle.
SERIESSUM functionReturns the sum of a power series based on the formula.
SIGN functionReturns the sign of a number.
SIN functionReturns the sine of the given angle.
SINH functionReturns the hyperbolic sine of a number.
SQRT functionReturns a positive square root.
SQRTPI functionReturns the square root of (number * pi).
SUBTOTAL functionReturns a subtotal in a list or database.
SUM functionAdds its arguments.
SUMIF functionAdds the cells specified by a given criteria.
SUMIFS functionAdds the cells in a range that meet multiple criteria.
SUMPRODUCT functionReturns the sum of the products of corresponding array components.
SUMSQ functionReturns the sum of the squares of the arguments.
SUMX2MY2 functionReturns the sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2 functionReturns the sum of the sum of squares of corresponding values in two arrays.
SUMXMY2 functionReturns the sum of squares of differences of corresponding values in two arrays.
TAN functionReturns the tangent of a number.
TANH functionReturns the hyperbolic tangent of a number.
TRUNC functionTruncates a number to an integer.

Important: The calculated results of formulas and some Excel worksheet functions might change to some degree between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

See Also

Excel functions (by category)

Excel functions (alphabetical)

Other Links

Back to Software Bytes – Official Website

Back to Excel Tutorial

Leave a Reply

%d bloggers like this: