Complete List of Excel Engineering Functions References and Examples

by

Excel Engineering Functions perform the most commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases.

Here’s a full list of Built-In Engineering Functions in Excel and their Descriptions below:

Click each of the function link to see detailed example.

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 user-supplied 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 base-10 logarithm of a complex number
IMLOG2	Returns the base-2 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)

Leave a Reply Cancel reply