To get detailed information about a function, click its name in the first column.

Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.

 Function Description Returns the modified Bessel function In(x) Returns the Bessel function Jn(x) Returns the modified Bessel function Kn(x) Returns the Bessel function Yn(x) Converts a binary number to decimal Converts a binary number to hexadecimal Converts a binary number to octal BITAND function Returns a bitwise 'And' of two numbers BITLSHIFT function Returns a number shifted left by shift_amount bits BITOR function Returns a bitwise 'Or' of two numbers BITRSHIFT function Returns a number shifted right by shift_amount bits BITXOR function Returns a bitwise 'Exclusive Or' of two numbers Converts real and imaginary coefficients into a complex number Converts a number from one measurement system to another Converts a decimal number to binary Converts a decimal number to hexadecimal Converts a decimal number to octal Tests whether two values are equal Returns the error function ERF.PRECISE function Returns the error function Returns the complementary error function ERFC.PRECISE function Returns the complementary ERF function integrated between x and infinity Tests whether a number is greater than a threshold value Converts a hexadecimal number to binary Converts a hexadecimal number to decimal Converts a hexadecimal number to octal Returns the absolute value (modulus) of a complex number Returns the imaginary coefficient of a complex number Returns the argument theta, an angle expressed in radians Returns the complex conjugate of a complex number Returns the cosine of a complex number IMCOSH function Returns the hyperbolic cosine of a complex number IMCOT function Returns the cotangent of a complex number IMCSC function Returns the cosecant of a complex number IMCSCH function Returns the hyperbolic cosecant of a complex number Returns the quotient of two complex numbers Returns the exponential of a complex number Returns the natural logarithm of a complex number Returns the base-10 logarithm of a complex number Returns the base-2 logarithm of a complex number Returns a complex number raised to an integer power Returns the product of from 2 to 255 complex numbers Returns the real coefficient of a complex number IMSEC function Returns the secant of a complex number IMSECH function Returns the hyperbolic secant of a complex number Returns the sine of a complex number IMSINH function Returns the hyperbolic sine of a complex number Returns the square root of a complex number Returns the difference between two complex numbers Returns the sum of complex numbers IMTAN function Returns the tangent of a complex number Converts an octal number to binary Converts an octal number to decimal Converts an octal number to hexadecimal

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

Excel functions (by category)

Excel functions (alphabetical)