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.
Try itEngineering (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.