Engineering functions reference

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
BESSELI function	Returns the modified Bessel function In(x)
BESSELJ function	Returns the Bessel function Jn(x)
BESSELK function	Returns the modified Bessel function Kn(x)
BESSELY function	Returns the Bessel function Yn(x)
BIN2DEC function	Converts a binary number to decimal
BIN2HEX function	Converts a binary number to hexadecimal
BIN2OCT function	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
COMPLEX function	Converts real and imaginary coefficients into a complex number
CONVERT function	Converts a number from one measurement system to another
DEC2BIN function	Converts a decimal number to binary
DEC2HEX function	Converts a decimal number to hexadecimal
DEC2OCT function	Converts a decimal number to octal
DELTA function	Tests whether two values are equal
ERF function	Returns the error function
ERF.PRECISE function	Returns the error function
ERFC function	Returns the complementary error function
ERFC.PRECISE function	Returns the complementary ERF function integrated between x and infinity
GESTEP function	Tests whether a number is greater than a threshold value
HEX2BIN function	Converts a hexadecimal number to binary
HEX2DEC function	Converts a hexadecimal number to decimal
HEX2OCT function	Converts a hexadecimal number to octal
IMABS function	Returns the absolute value (modulus) of a complex number
IMAGINARY function	Returns the imaginary coefficient of a complex number
IMARGUMENT function	Returns the argument theta, an angle expressed in radians
IMCONJUGATE function	Returns the complex conjugate of a complex number
IMCOS function	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
IMDIV function	Returns the quotient of two complex numbers
IMEXP function	Returns the exponential of a complex number
IMLN function	Returns the natural logarithm of a complex number
IMLOG10 function	Returns the base-10 logarithm of a complex number
IMLOG2 function	Returns the base-2 logarithm of a complex number
IMPOWER function	Returns a complex number raised to an integer power
IMPRODUCT function	Returns the product of from 2 to 255 complex numbers
IMREAL function	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
IMSIN function	Returns the sine of a complex number
IMSINH function	Returns the hyperbolic sine of a complex number
IMSQRT function	Returns the square root of a complex number
IMSUB function	Returns the difference between two complex numbers
IMSUM function	Returns the sum of complex numbers
IMTAN function	Returns the tangent of a complex number
OCT2BIN function	Converts an octal number to binary
OCT2DEC function	Converts an octal number to decimal
OCT2HEX function	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)