Math & Trig
★ 8 · ◉ 18 · All versions
=LCM()
Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.
=LCM(number1, [number2], ...)
Rounding & Numeric
Scientific & Unit Conversion
Math & Trig
★ 40 · ◉ 18 · All versions
=SQRT()
Returns a positive square root.
=SQRT(number)
Rounding & Numeric
Scientific & Unit Conversion
Math & Trig
★ 6 · ◉ 15 · Excel 2013
=BASE()
Converts a number into a text representation with the given radix (base).
=BASE(Number, Radix [Min_length])
Scientific & Unit Conversion
Math & Trig
★ 15 · ◉ 14 · All versions
=COMBIN()
Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
=COMBIN(number, number_chosen)
Probability & Hypothesis Testing
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 14 · All versions
=RADIANS()
Converts degrees to radians.
=RADIANS(angle)
Scientific & Unit Conversion
Engineering
★ 35 · ◉ 13 · All versions
=CONVERT()
units for the result. CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit.
=CONVERT(number,from_unit,to_unit)
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 13 · All versions
=GCD()
Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
=GCD(number1, [number2], ...)
Rounding & Numeric
Scientific & Unit Conversion
Math & Trig
★ 15 · ◉ 13 · All versions
=LN()
Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
=LN(number)
Scientific & Unit Conversion
Math & Trig
★ 8 · ◉ 13 · All versions
=LOG10()
Returns the base-10 logarithm of a number.
=LOG10(number)
Scientific & Unit Conversion
Engineering
★ 17 · ◉ 11 · All versions
=DEC2HEX()
Converts a decimal number to hexadecimal.
=DEC2HEX(number, [places])
Scientific & Unit Conversion
Engineering
★ 37 · ◉ 11 · All versions
=ERFC()
Returns the complementary ERF function integrated between x and infinity.
=ERFC(x)
Scientific & Unit Conversion
Math & Trig
★ 12 · ◉ 11 · All versions
=FACT()
Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.
=FACT(number)
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 11 · All versions
=SIN()
Returns the sine of the given angle.
=SIN(number)
Scientific & Unit Conversion
Math & Trig
★ 15 · ◉ 11 · All versions
=SUMSQ()
Returns the sum of the squares of the arguments.
=SUMSQ(number1, [number2], ...)
Scientific & Unit Conversion
Math & Trig
★ 3 · ◉ 11 · All versions
=SUMX2MY2()
This Excel function returns the sum of the difference of the squares of corresponding values in two arrays.
=SUMX2MY2(array_x, array_y)
Scientific & Unit Conversion
Math & Trig
★ 5 · ◉ 10 · Excel 2013
=DECIMAL()
Converts a text representation of a number in a given base into a decimal number.
=DECIMAL(text, radix)
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 10 · All versions
=IMCOT()
Returns the cotangent of a complex number in x+yi or x+yj text format.
=IMCOT(inumber)
Scientific & Unit Conversion
Engineering
★ 23 · ◉ 10 · All versions
=IMEXP()
Returns the exponential of a complex number in x + yi or x + yj text format.
=IMEXP(inumber)
Scientific & Unit Conversion
Engineering
★ 34 · ◉ 10 · All versions
=IMLN()
Returns the natural logarithm of a complex number in x + yi or x + yj text format.
=IMLN(inumber)
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 10 · All versions
=POWER()
(number, power)
=POWER(number, power)
Rounding & Numeric
Scientific & Unit Conversion
Engineering
★ 37 · ◉ 9 · All versions
=BESSELJ()
Returns the Bessel function.
=BESSELJ(X, N)
Scientific & Unit Conversion
Engineering
★ 22 · ◉ 9 · All versions
=BESSELY()
Returns the Bessel function, which is also called the Weber function or the Neumann function.
=BESSELY(X, N)
Scientific & Unit Conversion
Engineering
★ 28 · ◉ 9 · Excel 2013
=BITAND()
Returns a bitwise 'AND' of two numbers.
=BITAND( number1, number2)
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 9 · All versions
=COS()
Returns the cosine of the given angle.
=COS(number)
Scientific & Unit Conversion
Math & Trig
★ 8 · ◉ 9 · All versions
=DEGREES()
Converts radians into degrees.
=DEGREES(angle)
Scientific & Unit Conversion
Math & Trig
★ 15 · ◉ 9 · All versions
=EXP()
Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.
=EXP(number)
Scientific & Unit Conversion
Engineering
★ 28 · ◉ 9 · All versions
=HEX2DEC()
Converts a hexadecimal number to decimal.
=HEX2DEC(number)
Scientific & Unit Conversion
Engineering
★ 17 · ◉ 9 · All versions
=IMLOG10()
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
=IMLOG10(inumber)
Scientific & Unit Conversion
Engineering
★ 28 · ◉ 9 · All versions
=IMPOWER()
Returns a complex number in x + yi or x + yj text format raised to a power.
=IMPOWER(inumber, number)
Scientific & Unit Conversion
Math & Trig
★ 20 · ◉ 9 · All versions
=PRODUCT()
The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform the same operation by using the multiply (*) mathematical operator; for example, =A1 * A2. The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.
=PRODUCT(number1, [number2], ...)
Rounding & Numeric
Scientific & Unit Conversion
Math & Trig
★ 8 · ◉ 9 · All versions
=TAN()
Returns the tangent of the given angle.
=TAN(number)
Scientific & Unit Conversion
Engineering
★ 15 · ◉ 9 · All versions
=OCT2BIN()
Converts an octal number to binary.
=OCT2BIN(number, [places])
Scientific & Unit Conversion
Engineering
★ 27 · ◉ 8 · All versions
=BIN2DEC()
Converts a binary number to decimal.
=BIN2DEC(number)
Scientific & Unit Conversion
Statistical
★ 3 · ◉ 8 · Excel 2013
=GAMMA()
Return the gamma function value.
=GAMMA(number)
Probability & Hypothesis Testing
Scientific & Unit Conversion
Engineering
★ 44 · ◉ 8 · All versions
=HEX2OCT()
Converts a hexadecimal number to octal.
=HEX2OCT(number, [places])
Scientific & Unit Conversion
Engineering
★ 21 · ◉ 8 · All versions
=IMARGUMENT()
Returns the argument (theta), an angle expressed in radians, such that:
=IMARGUMENT(inumber)
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 8 · All versions
=IMCSCH()
Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format.
=IMCSCH(inumber)
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 8 · All versions
=IMSEC()
Returns the secant of a complex number in x+yi or x+yj text format.
=IMSEC(inumber)
Scientific & Unit Conversion
Engineering
★ 25 · ◉ 8 · All versions
=IMSUM()
Returns the sum of two or more complex numbers in x + yi or x + yj text format.
=IMSUM(inumber1, [inumber2], ...)
Scientific & Unit Conversion
Math & Trig
★ 15 · ◉ 8 · All versions
=LOG()
Returns the logarithm of a number to the base you specify.
=LOG(number, [base])
Scientific & Unit Conversion
Math & Trig
★ 3 · ◉ 8 · Excel 2013
=MUNIT()
The MUNIT function returns the unit matrix for the specified dimension.
=MUNIT(dimension)
Scientific & Unit Conversion
Math & Trig
★ 15 · ◉ 8 · All versions
=PI()
Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
=PI()
Scientific & Unit Conversion
Math & Trig
★ 6 · ◉ 8 · All versions
=ROMAN()
Converts an arabic numeral to roman, as text.
=ROMAN(number, [form])
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 7 · All versions
=BIN2HEX()
Converts a binary number to hexadecimal.
=BIN2HEX(number, [places])
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 7 · Excel 2013
=BITOR()
Returns a bitwise 'OR' of two numbers.
=BITOR(number1, number2)
Scientific & Unit Conversion
Engineering
★ 23 · ◉ 7 · Excel 2013
=BITRSHIFT()
Returns a number shifted right by the specified number of bits.
=BITRSHIFT(number, shift_amount)
Scientific & Unit Conversion
Engineering
★ 40 · ◉ 7 · All versions
=COMPLEX()
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
=COMPLEX(real_num, i_num, [suffix])
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 7 · All versions
=HEX2BIN()
Converts a hexadecimal number to binary.
=HEX2BIN(number, [places])
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 7 · All versions
=IMCONJUGATE()
Returns the complex conjugate of a complex number in x + yi or x + yj text format.
=IMCONJUGATE(inumber)
Scientific & Unit Conversion
Engineering
★ 21 · ◉ 7 · All versions
=IMREAL()
Returns the real coefficient of a complex number in x + yi or x + yj text format.
=IMREAL(inumber)
Scientific & Unit Conversion
Engineering
★ 44 · ◉ 7 · All versions
=IMSQRT()
Returns the square root of a complex number in x + yi or x + yj text format.
=IMSQRT(inumber)
Scientific & Unit Conversion
Engineering
★ 21 · ◉ 7 · All versions
=IMSUB()
Returns the difference of two complex numbers in x + yi or x + yj text format. If you just want to subtract two numbers that are not complex, see Subtract numbers.
=IMSUB(inumber1, inumber2)
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 7 · All versions
=MMULT()
The MMULT function returns the matrix product or multiplication of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. The way you enter the formula depends on which version of Office 365 you are using.
=MMULT(array1, array2)
Advanced Formulas
Scientific & Unit Conversion
Math & Trig
★ 5 · ◉ 6 · Excel 2013
=ARABIC()
Converts a Roman numeral to an Arabic numeral.
=ARABIC( text )
Scientific & Unit Conversion
Engineering
★ 43 · ◉ 6 · All versions
=BESSELK()
Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments.
=BESSELK(X, N)
Scientific & Unit Conversion
Engineering
★ 35 · ◉ 6 · Excel 2013
=BITXOR()
Returns a bitwise 'XOR' of two numbers.
=BITXOR(number1, number2)
Scientific & Unit Conversion
Engineering
★ 36 · ◉ 6 · All versions
=IMABS()
Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
=IMABS(inumber)
Scientific & Unit Conversion
Engineering
★ 39 · ◉ 6 · All versions
=IMAGINARY()
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
=IMAGINARY(inumber)
Scientific & Unit Conversion
Engineering
★ 18 · ◉ 6 · All versions
=IMCOSH()
Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format.
=IMCOSH(inumber)
Scientific & Unit Conversion
Engineering
★ 33 · ◉ 6 · All versions
=IMCSC()
Returns the cosecant of a complex number in x+yi or x+yj text format.
=IMCSC(inumber)
Scientific & Unit Conversion
Engineering
★ 38 · ◉ 6 · All versions
=IMDIV()
Returns the quotient of two complex numbers in x + yi or x + yj text format.
=IMDIV(inumber1, inumber2)
Scientific & Unit Conversion
Engineering
★ 37 · ◉ 6 · All versions
=IMPRODUCT()
Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format.
=IMPRODUCT(inumber1, [inumber2], ...)
Scientific & Unit Conversion
Engineering
★ 20 · ◉ 6 · All versions
=IMSECH()
Returns the hyperbolic secant of a complex number in x+yi or x+yj text format.
=IMSECH(inumber)
Scientific & Unit Conversion
Engineering
★ 35 · ◉ 6 · All versions
=IMSINH()
The IMSINH function returns the hyperbolic sine of a complex number in x+yi or x+yj text format.
=IMSINH(inumber)
Scientific & Unit Conversion
Engineering
★ 31 · ◉ 6 · All versions
=OCT2DEC()
Converts an octal number to decimal.
=OCT2DEC(number)
Scientific & Unit Conversion
Engineering
★ 20 · ◉ 5 · All versions
=DEC2BIN()
Converts a decimal number to binary.
=DEC2BIN(number, [places])
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 5 · All versions
=DEC2OCT()
Converts a decimal number to octal.
=DEC2OCT(number, [places])
Scientific & Unit Conversion
Engineering
★ 16 · ◉ 5 · All versions
=IMCOS()
Returns the cosine of a complex number in x + yi or x + yj text format.
=IMCOS(inumber)
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 4 · Excel 2013
=BITLSHIFT()
Returns a number shifted left by the specified number of bits.
=BITLSHIFT(number, shift_amount)
Scientific & Unit Conversion
Engineering
★ 41 · ◉ 4 · All versions
=ERF()
Returns the error function integrated between lower_limit and upper_limit.
=ERF(lower_limit,[upper_limit])
Scientific & Unit Conversion
Engineering
★ 18 · ◉ 4 · All versions
=GESTEP()
Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold.
=GESTEP(number, [step])
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 4 · All versions
=IMSIN()
Returns the sine of a complex number in x + yi or x + yj text format.
=IMSIN(inumber)
Scientific & Unit Conversion
Engineering
★ 31 · ◉ 3 · All versions
=BESSELI()
Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
=BESSELI(X, N)
Scientific & Unit Conversion
Engineering
★ 43 · ◉ 3 · All versions
=BIN2OCT()
Converts a binary number to octal.
=BIN2OCT(number, [places])
Scientific & Unit Conversion
Engineering
★ 32 · ◉ 3 · All versions
=DELTA()
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.
=DELTA(number1, [number2])
Scientific & Unit Conversion
Engineering
★ 38 · ◉ 3 · All versions
=IMTAN()
Returns the tangent of a complex number in x+yi or x+yj text format.
=IMTAN(inumber)
Scientific & Unit Conversion
Engineering
★ 21 · ◉ 2 · All versions
=IMLOG2()
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.
=IMLOG2(inumber)
Scientific & Unit Conversion
Engineering
★ 45 · ◉ 1 · All versions
=OCT2HEX()
Converts an octal number to hexadecimal.
=OCT2HEX(number, [places])
Scientific & Unit Conversion