# 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

Returns a bitwise 'And' of two numbers

Returns a number shifted left by shift_amount bits

Returns a bitwise 'Or' of two numbers

Returns a number shifted right by shift_amount bits

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

Returns the error function

Returns the complementary error 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

Returns the hyperbolic cosine of a complex number

Returns the cotangent of a complex number

Returns the cosecant of a complex number

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

Returns the secant of a complex number

Returns the hyperbolic secant of a complex number

Returns the sine of a complex number

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

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