# 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

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.

### Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

×