# Excel Engineering Functions

The Excel Engineering Functions perform the most commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases. Engineers may also find the Excel Math and Trig functions useful.

In the tables below, the Excel Engineering functions have been grouped into categories, to help you to find the function you need. Selecting a function name will take you to a full description of the function with examples of use.

Note that some of the functions are new to Excel 2010 or Excel 2013 and so are not available in earlier versions of Excel.

## Excel Engineering Functions

 Converting Between Units of Measurement CONVERT Converts a number from one measurement system to another Bessel Functions BESSELI Calculates the modified Bessel function In(x) BESSELJ Calculates the Bessel function Jn(x) BESSELK Calculates the modified Bessel function Kn(x) BESSELY Calculates the modified Bessel function Yn(x) Converting Between Bases BIN2DEC Converts a binary number to a decimal BIN2HEX Converts a binary number to hexadecimal BIN2OCT Converts a binary number to octal DEC2BIN Converts a decimal number to binary DEC2HEX Converts a decimal number to hexadecimal DEC2OCT Converts a decimal number to octal HEX2BIN Converts a hexadecimal number to binary HEX2DEC Converts a hexadecimal number to a decimal HEX2OCT Converts a hexadecimal number to octal OCT2BIN Converts octal number to binary OCT2DEC Converts octal number to a decimal OCT2HEX Converts octal number to hexadecimal The Error Function ERF Returns the error function integrated between two supplied limits ERF.PRECISE Returns the error function integrated between 0 and a supplied limit (New in Excel 2010) ERFC Returns the complementary error function integrated between a supplied lower limit and infinity ERFC.PRECISE Returns the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010) Bitwise Functions BITAND Returns a Bitwise 'And' of two numbers (New in Excel 2013) BITOR Returns a Bitwise 'Or' of two numbers (New in Excel 2013) BITXOR Returns a Bitwise 'Exclusive Or' of two numbers (New in Excel 2013) BITLSHIFT Returns a number shifted left by a specified number of bits (New in Excel 2013) BITRSHIFT Returns a number shifted right by a specified number of bits (New in Excel 2013)
 Testing Numeric Values DELTA Tests whether two supplied numbers are equal GESTEP Tests whether a number is greater than a supplied threshold value Complex Numbers COMPLEX Converts user-supplied real and imaginary coefficients into a complex number IMABS Returns the absolute value (the modulus) of a complex number IMAGINARY Returns the imaginary coefficient of a complex number IMARGUMENT Returns the argument Θ (an angle expressed in radians) of a complex number IMCONJUGATE Returns the complex conjugate of a complex number IMCOS Returns the cosine of a complex number IMCOSH Returns the hyperbolic cosine of a complex number (New in Excel 2013) IMCOT Returns the cotangent of a complex number (New in Excel 2013) IMCSC Returns the cosecant of a complex number (New in Excel 2013) IMCSCH Returns the hyperbolic cosecant of a complex number (New in Excel 2013) IMDIV Returns the quotient of two supplied complex numbers IMEXP Returns the exponential of a complex number IMLN Returns the natural logarithm of a complex number IMLOG10 Returns the base-10 logarithm of a complex number IMLOG2 Returns the base-2 logarithm of a complex number IMPOWER Calculates a complex number raised to a supplied power IMPRODUCT Returns the product of up to 255 supplied complex numbers IMREAL Returns the real coefficient of a complex number IMSEC Returns the secant of a complex number (New in Excel 2013) IMSECH Returns the hyperbolic secant of a complex number (New in Excel 2013) IMSIN Returns the sine of a complex number IMSINH Returns the hyperbolic sine of a complex number (New in Excel 2013) IMSQRT Returns the square root of a complex number IMSUB Subtracts two complex numbers IMSUM Calculates the sum of two complex numbers IMTAN Returns the tangent of a complex number (New in Excel 2013)

### Analysis Toolpak

If the Excel Engineering functions are not available to you, you will need to load the Analysis Toolpak.