Home »
ExcelBuiltInFunctions »
ExcelEngineeringFunctions
Excel Engineering Functions
The builtin Excel Engineering Functions have been provided to 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, to help you to
find the function you need. Note that some of the functions are new to Excel 2010, so are not available
in earlier versions of Excel. Selecting a function name will take you to a full description of the
function with examples of use.
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 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:
 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