logo
excelfunctions.org
bookmarks

Math Basics

Math Basics functions cover the core calculations that appear in almost every spreadsheet—everything from simple arithmetic helpers to rounding and common trigonometry.

This collection groups Excel functions that are commonly used for math basics workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.

Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.

If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.

Tips
  • Start with the most common functions in this collection and expand as your problems get more complex.
  • Combine these functions with structured tables to keep formulas readable and resilient.

Excel functions in this collection (80)

Returns the absolute value of a number.

Math & TrigonometryMath Basics

Returns the arccosine of a number.

Math & TrigonometryMath Basics

Returns the inverse hyperbolic cosine of a number.

Math & TrigonometryMath Basics

Returns the arccotangent of a number.

Math & TrigonometryMath Basics

Returns the hyperbolic arccotangent of a number.

Math & TrigonometryMath Basics

Returns an aggregate in a list or database.

Math & TrigonometryMath Basics

Converts a Roman number to Arabic, as a number.

Math & TrigonometryMath Basics

Returns the arcsine of a number.

Math & TrigonometryMath Basics

Returns the inverse hyperbolic sine of a number.

Math & TrigonometryMath Basics

Returns the arctangent of a number.

Math & TrigonometryMath Basics

Returns the arctangent from x- and y-coordinates.

Math & TrigonometryMath Basics

Returns the inverse hyperbolic tangent of a number.

Math & TrigonometryMath Basics

Converts a number into a text representation with the given radix (base).

Math & TrigonometryMath Basics

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

Math & TrigonometryMath Basics

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

Math & TrigonometryMath Basics

Returns the number of combinations for a given number of objects.

Math & TrigonometryMath Basics

Returns the number of combinations with repetitions for a given number of items.

Math & TrigonometryMath Basics

Returns the cosine of a number.

Math & TrigonometryMath Basics

Returns the hyperbolic cosine of a number.

Math & TrigonometryMath Basics

Returns the hyperbolic cosine of a number.

Math & TrigonometryMath Basics

Returns the cotangent of an angle.

Math & TrigonometryMath Basics

Returns the cosecant of an angle.

Math & TrigonometryMath Basics

Returns the hyperbolic cosecant of an angle.

Math & TrigonometryMath Basics

Converts a text representation of a number in a given base into a decimal number.

Math & TrigonometryMath Basics

Converts radians to degrees.

Math & TrigonometryMath Basics

Rounds a number up to the nearest even integer.

Math & TrigonometryMath Basics

Returns e raised to the power of a given number.

Math & TrigonometryMath Basics

Returns the factorial of a number.

Math & TrigonometryMath Basics

Returns the double factorial of a number.

Math & TrigonometryMath Basics

Rounds a number down, to the nearest integer or to the nearest multiple of significance.

Math & TrigonometryMath Basics

Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

Math & TrigonometryMath Basics

Returns the greatest common divisor.

Math & TrigonometryMath Basics

Rounds a number down to the nearest integer.

Math & TrigonometryMath Basics

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.

Math & TrigonometryMath Basics

Returns the least common multiple.

Math & TrigonometryMath Basics

Returns the natural logarithm of a number.

Math & TrigonometryMath Basics

Returns the logarithm of a number to a specified base.

Math & TrigonometryMath Basics

Returns the base-10 logarithm of a number.

Math & TrigonometryMath Basics

Returns the matrix determinant of an array.

Math & TrigonometryMath Basics

Returns the matrix inverse of an array.

Math & TrigonometryMath Basics

Returns the matrix product of two arrays.

Math & TrigonometryMath Basics

Returns the remainder from division.

Math & TrigonometryMath Basics

Returns a number rounded to the desired multiple.

Math & TrigonometryMath Basics

Returns the multinomial of a set of numbers.

Math & TrigonometryMath Basics

Returns the unit matrix or the specified dimension.

Math & TrigonometryMath Basics

Rounds a number up to the nearest odd integer.

Math & TrigonometryMath Basics

Sums the values in the subset and divides it by all the values.

Math & TrigonometryMath BasicsModern Excel Functions

Returns the value of pi.

Math & TrigonometryMath Basics

Returns the result of a number raised to a power.

Math & TrigonometryMath Basics

Multiplies its arguments.

Math & TrigonometryMath Basics

Returns the integer portion of a division.

Math & TrigonometryMath Basics

Converts degrees to radians.

Math & TrigonometryMath Basics

Returns a random number between 0 and 1.

Math & TrigonometryMath Basics

Returns 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.

Math & TrigonometryMath BasicsModern Excel Functions

Returns a random number between the numbers you specify.

Math & TrigonometryMath Basics

Converts an arabic numeral to roman, as text.

Math & TrigonometryMath Basics

Rounds a number to a specified number of digits.

Math & TrigonometryBeginner EssentialsMath BasicsMost Used

Rounds a number down, toward zero.

Math & TrigonometryMath BasicsMost Used

Rounds a number up, away from zero.

Math & TrigonometryMath BasicsMost Used

Returns the secant of an angle.

Math & TrigonometryMath Basics

Returns the hyperbolic secant of an angle.

Math & TrigonometryMath Basics

Generates a list of sequential numbers in an array, such as 1, 2, 3, 4.

Math & TrigonometryDynamic Arrays & LAMBDAMath BasicsModern Excel Functions

Returns the sum of a power series based on the formula.

Math & TrigonometryMath Basics

Returns the sign of a number.

Math & TrigonometryMath Basics

Returns the sine of the given angle.

Math & TrigonometryMath Basics

Returns the hyperbolic sine of a number.

Math & TrigonometryMath Basics

Returns a positive square root.

Math & TrigonometryMath Basics

Returns the square root of (number * pi).

Math & TrigonometryMath Basics

Returns a subtotal in a list or database.

Math & TrigonometryMath Basics

Adds its arguments.

Math & TrigonometryBeginner EssentialsMath BasicsMost Used

Adds the cells specified by a given criteria.

Math & TrigonometryBeginner EssentialsMath BasicsMost Used

Adds the cells in a range that meet multiple criteria.

Math & TrigonometryMath BasicsMost Used

Returns the sum of the products of corresponding array components.

Math & TrigonometryMath Basics

Returns the sum of the squares of the arguments.

Math & TrigonometryMath Basics

Returns the sum of the difference of squares of corresponding values in two arrays.

Math & TrigonometryMath Basics

Returns the sum of the sum of squares of corresponding values in two arrays.

Math & TrigonometryMath Basics

Returns the sum of squares of differences of corresponding values in two arrays.

Math & TrigonometryMath Basics

Returns the tangent of a number.

Math & TrigonometryMath Basics

Returns the hyperbolic tangent of a number.

Math & TrigonometryMath Basics

Truncates a number to an integer.

Math & TrigonometryMath Basics