Home »
ExcelBuiltInFunctions »
ExcelEngineeringFunctions
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
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)

