Excel functions

Every Excel function (476), organized by category. Arguments in [brackets] are optional.

Formula Explainer · Paste any formula and see it broken down step by step. Free.

Engineering (54)

=BESSELI(X, N)

Returns the modified Bessel function In(x).

=BESSELJ(X, N)

Returns the Bessel function Jn(x).

=BESSELK(X, N)

Returns the modified Bessel function Kn(x).

=BESSELY(X, N)

Returns the Bessel function Yn(x).

=BIN2DEC(number)

Converts a binary number to decimal.

=BIN2HEX(number, [places])

Converts a binary number to hexadecimal.

=BIN2OCT(number, [places])

Converts a binary number to octal.

=BITAND(number1, number2)

Returns a 'Bitwise And' of two numbers.

=BITLSHIFT(number, shift_amount)

Returns a value number shifted left by shift_amount bits.

=BITOR(number1, number2)

Returns a bitwise OR of 2 numbers.

=BITRSHIFT(number, shift_amount)

Returns a value number shifted right by shift_amount bits.

=BITXOR(number1, number2)

Returns a bitwise 'Exclusive Or' of two numbers.

=COMPLEX(real_num, i_num, [suffix])

Converts real and imaginary coefficients into a complex number.

=CONVERT(number, from_unit, to_unit)

Converts a number from one measurement system to another.

=DEC2BIN(number, [places])

Converts a decimal number to binary.

=DEC2HEX(number, [places])

Converts a decimal number to hexadecimal.

=DEC2OCT(number, [places])

Converts a decimal number to octal.

=DELTA(number1, [number2])

Tests whether two values are equal.

=ERF(lower_limit, [upper_limit])

Returns the error function.

=ERF.PRECISE(x)

Returns the error function.

=ERFC(x)

Returns the complementary error function.

=ERFC.PRECISE(x)

Returns the complementary ERF function integrated between x and infinity.

=GESTEP(number, [step])

Tests whether a number is greater than a threshold value.

=HEX2BIN(number, [places])

Converts a hexadecimal number to binary.

=HEX2DEC(number)

Converts a hexadecimal number to decimal.

=HEX2OCT(number, [places])

Converts a hexadecimal number to octal.

=IMABS(inumber)

Returns the absolute value (modulus) of a complex number.

=IMAGINARY(inumber)

Returns the imaginary coefficient of a complex number.

=IMARGUMENT(inumber)

Returns the argument theta, an angle expressed in radians.

=IMCONJUGATE(inumber)

Returns the complex conjugate of a complex number.

=IMCOS(inumber)

Returns the cosine of a complex number.

=IMCOSH(inumber)

Returns the hyperbolic cosine of a complex number.

=IMCOT(inumber)

Returns the cotangent of a complex number.

=IMCSC(inumber)

Returns the cosecant of a complex number.

=IMCSCH(inumber)

Returns the hyperbolic cosecant of a complex number.

=IMDIV(inumber1, inumber2)

Returns the quotient of two complex numbers.

=IMEXP(inumber)

Returns the exponential of a complex number.

=IMLN(inumber)

Returns the natural logarithm of a complex number.

=IMLOG10(inumber)

Returns the base-10 logarithm of a complex number.

=IMLOG2(inumber)

Returns the base-2 logarithm of a complex number.

=IMPOWER(inumber, number)

Returns a complex number raised to an integer power.

=IMPRODUCT(inumber1, [inumber2], ...)

Returns the product of from 2 to 255 complex numbers.

=IMREAL(inumber)

Returns the real coefficient of a complex number.

=IMSEC(inumber)

Returns the secant of a complex number.

=IMSECH(inumber)

Returns the hyperbolic secant of a complex number.

=IMSIN(inumber)

Returns the sine of a complex number.

=IMSINH(inumber)

Returns the hyperbolic sine of a complex number.

=IMSQRT(inumber)

Returns the square root of a complex number.

=IMSUB(inumber1, inumber2)

Returns the difference between two complex numbers.

=IMSUM(inumber1, [inumber2], ...)

Returns the sum of complex numbers.

=IMTAN(inumber)

Returns the tangent of a complex number.

=OCT2BIN(number, [places])

Converts an octal number to binary.

=OCT2DEC(number)

Converts an octal number to decimal.

=OCT2HEX(number, [places])

Converts an octal number to hexadecimal.