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.

Function | Category | Description |
---|---|---|

BESSELI | Bessel | Returns the modified Bessel function In(x) |

BESSELJ | Bessel | Returns the Bessel function Jn(x) |

BESSELK | Bessel | Returns the modified Bessel function Kn(x) |

BESSELY | Bessel | Returns the Bessel function Yn(x) |

BIN2DEC | Convert Bases | Converts a binary number to decimal |

BIN2HEX | Convert Bases | Converts a binary number to hexadecimal |

BIN2OCT | Convert Bases | Converts a binary number to octal |

BITAND | Bitwise | Returns a 'Bitwise And' of two numbers (New in Excel 2013) |

BITLSHIFT | Bitwise | Returns a value number shifted left by shift_amount bits (New in Excel 2013) |

BITOR | Bitwise | Returns a bitwise OR of 2 numbers (New in Excel 2013) |

BITRSHIFT | Bitwise | Returns a value number shifted right by shift_amount bits (New in Excel 2013) |

BITXOR | Bitwise | Returns a bitwise 'Exclusive Or' of two numbers (New in Excel 2013) |

COMPLEX | Complex Numbers | Converts real and imaginary coefficients into a complex number |

CONVERT | Convert Measures | Converts a number from one measurement system to another |

DEC2BIN | Convert Bases | Converts a decimal number to binary |

DEC2HEX | Convert Bases | Converts a decimal number to hexadecimal |

DEC2OCT | Convert Bases | Converts a decimal number to octal |

DELTA | Testing Numerics | Tests whether two values are equal |

ERF | Error Functions | Returns the error function |

ERF.PRECISE | Error Functions | Returns the error function (New in Excel 2010) |

ERFC | Error Functions | Returns the complementary error function |

ERFC.PRECISE | Error Functions | Returns the complementary ERF function integrated between x and infinity (New in Excel 2010) |

GESTEP | Testing Numerics | Tests whether a number is greater than a threshold value |

HEX2BIN | Convert Bases | Converts a hexadecimal number to binary |

HEX2DEC | Convert Bases | Converts a hexadecimal number to decimal |

HEX2OCT | Convert Bases | Converts a hexadecimal number to octal |

IMABS | Complex Numbers | Returns the absolute value (modulus) of a complex number |

IMAGINARY | Complex Numbers | Returns the imaginary coefficient of a complex number |

IMARGUMENT | Complex Numbers | Returns the argument theta, an angle expressed in radians |

IMCONJUGATE | Complex Numbers | Returns the complex conjugate of a complex number |

IMCOS | Complex Numbers | Returns the cosine of a complex number |

IMCOSH | Complex Numbers | Returns the hyperbolic cosine of a complex number (New in Excel 2013) |

IMCOT | Complex Numbers | Returns the cotangent of a complex number (New in Excel 2013) |

IMCSC | Complex Numbers | Returns the cosecant of a complex number (New in Excel 2013) |

IMCSCH | Complex Numbers | Returns the hyperbolic cosecant of a complex number (New in Excel 2013) |

IMDIV | Complex Numbers | Returns the quotient of two complex numbers |

IMEXP | Complex Numbers | Returns the exponential of a complex number |

IMLN | Complex Numbers | Returns the natural logarithm of a complex number |

IMLOG10 | Complex Numbers | Returns the base-10 logarithm of a complex number |

IMLOG2 | Complex Numbers | Returns the base-2 logarithm of a complex number |

IMPOWER | Complex Numbers | Returns a complex number raised to an integer power |

IMPRODUCT | Complex Numbers | Returns the product of from 2 to 255 complex numbers |

IMREAL | Complex Numbers | Returns the real coefficient of a complex number |

IMSEC | Complex Numbers | Returns the secant of a complex number (New in Excel 2013) |

IMSECH | Complex Numbers | Returns the hyperbolic secant of a complex number (New in Excel 2013) |

IMSIN | Complex Numbers | Returns the sine of a complex number |

IMSINH | Complex Numbers | Returns the hyperbolic sine of a complex number (New in Excel 2013) |

IMSQRT | Complex Numbers | Returns the square root of a complex number |

IMSUB | Complex Numbers | Returns the difference between two complex numbers |

IMSUM | Complex Numbers | Returns the sum of complex numbers |

IMTAN | Complex Numbers | Returns the tangent of a complex number (New in Excel 2013) |

OCT2BIN | Convert Bases | Converts an octal number to binary |

OCT2DEC | Convert Bases | Converts an octal number to decimal |

OCT2HEX | Convert Bases | Converts an octal number to hexadecimal |