Excel Engineering Functions

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

The tables below list all the Excel Engineering functions, grouped into categories. Selecting a function name will take you to a full description of the function with examples of use.

Note that some of the functions (including the bitwise functions, introduced in Excel 2013) are only available in recent versions of Excel.


Excel Engineering Functions

Converting Between Units of Measurement
CONVERTConverts a number from one measurement system to another
Bessel Functions
BESSELICalculates the modified Bessel function In(x)
BESSELJCalculates the Bessel function Jn(x)
BESSELKCalculates the modified Bessel function Kn(x)
BESSELYCalculates the modified Bessel function Yn(x)
Converting Between Bases
BIN2DECConverts a binary number to a decimal
BIN2HEXConverts a binary number to hexadecimal
BIN2OCTConverts a binary number to octal
DEC2BINConverts a decimal number to binary
DEC2HEXConverts a decimal number to hexadecimal
DEC2OCTConverts a decimal number to octal
HEX2BINConverts a hexadecimal number to binary
HEX2DECConverts a hexadecimal number to a decimal
HEX2OCTConverts a hexadecimal number to octal
OCT2BINConverts octal number to binary
OCT2DECConverts octal number to a decimal
OCT2HEXConverts octal number to hexadecimal
The Error Function
ERFReturns the error function integrated between two supplied limits
ERF.PRECISEReturns the error function integrated between 0 and a supplied limit (New in Excel 2010)
ERFCReturns the complementary error function integrated between a supplied lower limit and infinity
ERFC.PRECISEReturns the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010)
Bitwise Functions
BITANDReturns a Bitwise 'And' of two numbers (New in Excel 2013)
BITORReturns a Bitwise 'Or' of two numbers (New in Excel 2013)
BITXORReturns a Bitwise 'Exclusive Or' of two numbers (New in Excel 2013)
BITLSHIFTReturns a number shifted left by a specified number of bits (New in Excel 2013)
BITRSHIFTReturns a number shifted right by a specified number of bits (New in Excel 2013)
Testing Numeric Values
DELTATests whether two supplied numbers are equal
GESTEPTests whether a number is greater than a supplied threshold value
Complex Numbers
COMPLEXConverts user-supplied real and imaginary coefficients into a complex number
IMABSReturns the absolute value (the modulus) of a complex number
IMAGINARYReturns the imaginary coefficient of a complex number
IMARGUMENTReturns the argument Θ (an angle expressed in radians) of a complex number
IMCONJUGATEReturns the complex conjugate of a complex number
IMCOSReturns the cosine of a complex number
IMCOSHReturns the hyperbolic cosine of a complex number (New in Excel 2013)
IMCOTReturns the cotangent of a complex number (New in Excel 2013)
IMCSCReturns the cosecant of a complex number (New in Excel 2013)
IMCSCHReturns the hyperbolic cosecant of a complex number (New in Excel 2013)
IMDIVReturns the quotient of two supplied complex numbers
IMEXPReturns the exponential of a complex number
IMLNReturns the natural logarithm of a complex number
IMLOG10Returns the base-10 logarithm of a complex number
IMLOG2Returns the base-2 logarithm of a complex number
IMPOWERCalculates a complex number raised to a supplied power
IMPRODUCTReturns the product of up to 255 supplied complex numbers
IMREALReturns the real coefficient of a complex number
IMSECReturns the secant of a complex number (New in Excel 2013)
IMSECHReturns the hyperbolic secant of a complex number (New in Excel 2013)
IMSINReturns the sine of a complex number
IMSINHReturns the hyperbolic sine of a complex number (New in Excel 2013)
IMSQRTReturns the square root of a complex number
IMSUBSubtracts two complex numbers
IMSUMCalculates the sum of two complex numbers
IMTANReturns 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 install the analysis toolpak.

  +   Show How to Do This in Excel 2003:

  +   Show How to Do This in Excel 2007:

  +   Show How to Do This in Excel 2010 or Excel 2013: