A graph of the spherical Bessel functions of t...

A graph of the spherical Bessel functions of the second kind: y_0(x) in red y_1(x) in green y_2(x) in blue (Photo credit: Wikipedia)

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 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.

FunctionCategoryDescription
BESSELIBesselReturns the modified Bessel function In(x)
BESSELJBesselReturns the Bessel function Jn(x)
BESSELKBesselReturns the modified Bessel function Kn(x)
BESSELYBesselReturns the Bessel function Yn(x)
BIN2DECConvert BasesConverts a binary number to decimal
BIN2HEXConvert BasesConverts a binary number to hexadecimal
BIN2OCTConvert BasesConverts a binary number to octal
BITANDBitwiseReturns a 'Bitwise And' of two numbers (New in Excel 2013)
BITLSHIFTBitwiseReturns a value number shifted left by shift_amount bits (New in Excel 2013)
BITORBitwiseReturns a bitwise OR of 2 numbers (New in Excel 2013)
BITRSHIFTBitwiseReturns a value number shifted right by shift_amount bits (New in Excel 2013)
BITXORBitwiseReturns a bitwise 'Exclusive Or' of two numbers (New in Excel 2013)
COMPLEXComplex NumbersConverts real and imaginary coefficients into a complex number
CONVERTConvert MeasuresConverts a number from one measurement system to another
DEC2BINConvert BasesConverts a decimal number to binary
DEC2HEXConvert BasesConverts a decimal number to hexadecimal
DEC2OCTConvert BasesConverts a decimal number to octal
DELTATesting NumericsTests whether two values are equal
ERFError FunctionsReturns the error function
ERF.PRECISEError FunctionsReturns the error function (New in Excel 2010)
ERFCError FunctionsReturns the complementary error function
ERFC.PRECISEError FunctionsReturns the complementary ERF function integrated between x and infinity (New in Excel 2010)
GESTEPTesting NumericsTests whether a number is greater than a threshold value
HEX2BINConvert BasesConverts a hexadecimal number to binary
HEX2DECConvert BasesConverts a hexadecimal number to decimal
HEX2OCTConvert BasesConverts a hexadecimal number to octal
IMABSComplex NumbersReturns the absolute value (modulus) of a complex number
IMAGINARYComplex NumbersReturns the imaginary coefficient of a complex number
IMARGUMENTComplex NumbersReturns the argument theta, an angle expressed in radians
IMCONJUGATEComplex NumbersReturns the complex conjugate of a complex number
IMCOSComplex NumbersReturns the cosine of a complex number
IMCOSHComplex NumbersReturns the hyperbolic cosine of a complex number (New in Excel 2013)
IMCOTComplex NumbersReturns the cotangent of a complex number (New in Excel 2013)
IMCSCComplex NumbersReturns the cosecant of a complex number (New in Excel 2013)
IMCSCHComplex NumbersReturns the hyperbolic cosecant of a complex number (New in Excel 2013)
IMDIVComplex NumbersReturns the quotient of two complex numbers
IMEXPComplex NumbersReturns the exponential of a complex number
IMLNComplex NumbersReturns the natural logarithm of a complex number
IMLOG10Complex NumbersReturns the base-10 logarithm of a complex number
IMLOG2Complex NumbersReturns the base-2 logarithm of a complex number
IMPOWERComplex NumbersReturns a complex number raised to an integer power
IMPRODUCTComplex NumbersReturns the product of from 2 to 255 complex numbers
IMREALComplex NumbersReturns the real coefficient of a complex number
IMSEC Complex NumbersReturns the secant of a complex number (New in Excel 2013)
IMSECH Complex NumbersReturns the hyperbolic secant of a complex number (New in Excel 2013)
IMSINComplex NumbersReturns the sine of a complex number
IMSINH Complex NumbersReturns the hyperbolic sine of a complex number (New in Excel 2013)
IMSQRTComplex NumbersReturns the square root of a complex number
IMSUBComplex NumbersReturns the difference between two complex numbers
IMSUMComplex NumbersReturns the sum of complex numbers
IMTAN Complex NumbersReturns the tangent of a complex number (New in Excel 2013)
OCT2BINConvert BasesConverts an octal number to binary
OCT2DECConvert BasesConverts an octal number to decimal
OCT2HEXConvert BasesConverts an octal number to hexadecimal