Home » ExcelBuiltInFunctions » ExcelEngineeringFunctions
Excel Engineering Functions
The builtin 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

CONVERT  Converts a number from one measurement system to another 

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) 

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 

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) 

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) 
 
DELTA  Tests whether two supplied numbers are equal  GESTEP  Tests whether a number is greater than a supplied threshold value 

COMPLEX  Converts usersupplied 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 base10 logarithm of a complex number  IMLOG2  Returns the base2 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 install the analysis toolpak.
+ Show How to Do This in Excel 2003:
 From the Tools dropdown menu, select the option AddIns ...
 An 'AddIns' window will pop up. From this, select the option Analysis ToolPak and click OK
+ Show How to Do This in Excel 2007:
 Click the Microsoft button on the top left of your spreadsheet and select
the Excel Options button
 From the menu on the left hand side, select AddIns
 In the 'Manage:' box, select Excel Addins and click Go...
 An 'AddIns' window will pop up. From this, select the option Analysis ToolPak and click OK
+ Show How to Do This in Excel 2010 or Excel 2013:
 Click the File tab (top left of your spreadsheet) and select Options
 From the menu on the left hand side, select AddIns
 If the window that pops up doesn't show the 'Addins' list, use the 'Manage:'
dropdown menu (at the bottom of the window) to select Excel Addins. Click Go...
 From the 'AddIns' window, select the option Analysis ToolPak and click OK