The Excel engineering functions are used to perform various engineering related calculations such as Bessel, bitwise, hexadecimal, secant, octal and much more. Some of the engineering formulas are new and may not be available in old versions.
Complete List of Excel Engineering Functions (A to Z)
All Excel engineering functions are mentioned below in alphabetical order:
| Function | Description |
| BESSELI Function | Modified Bessel formula In(x). |
| BESSELJ Function | Bessel formula Jn(x). |
| BESSELK Function | Modified Bessel function Kn(x). |
| BESSELY Function | Bessel function Yn(x). |
| BIN2DEC Function | From binary number to decimal. |
| BIN2HEX Function | From binary number to hexadecimal. |
| BIN2OCT Function | From binary number to octal. |
| BITAND Function | Bitwise AND of two numbers. |
| BITLSHIFT Function | Right shifted number by the given number of bits. |
| BITOR Function | Bitwise OR of two numbers. |
| BITRSHIFT Function | Left shifted number by the given number of bits. |
| BITXOR Function | Bitwise XOR of two numbers. |
| COMPLEX Function | From real and imaginary coefficients to a complex number. |
| CONVERT Function | From one measurement system to another. |
| DEC2BIN Function | From decimal number to binary. |
| DEC2HEX Function | From decimal number to hexadecimal. |
| DEC2OCT Function | From decimal number to octal. |
| DELTA Function | Checks whether two values are equal. |
| ERF Function | Error function, integrated between two limits. |
| ERF.PRECISE Function | Error function of a specified value. |
| ERFC Function | Complementary error function, integrated between x and infinity. |
| ERFC.PRECISE Function | Complementary error function, integrated between x and infinity. |
| GESTEP Function | Checks whether a number is greater than a specified threshold value. |
| HEX2BIN Function | From hexadecimal number to binary. |
| HEX2DEC Function | From hexadecimal number to decimal. |
| HEX2OCT Function | From hexadecimal number to octal. |
| IMABS Function | Absolute value of a complex number. |
| IMAGINARY Function | Imaginary coefficient of a complex number. |
| IMARGUMENT Function | Argument theta, an angle expressed in radians, of a given complex number. |
| IMCONJUGATE Function | Complex conjugate of a given complex number. |
| IMCOS Function | Cosine of a given complex number. |
| IMCOSH Function | Hyperbolic cosine of a given complex number. |
| IMCOT Function | Cotangent of a given complex number. |
| IMCOSC Function | Cosecant of a given complex number. |
| IMCOSCH Function | Hyperbolic cosecant of a given complex number. |
| IMDIV Function | Quotient of two specified complex numbers. |
| IMEXP Function | Exponential of a given complex number. |
| IMLN Function | Natural logarithm of a given complex number. |
| IMLOG10 Function | Base-10 logarithm of given a complex number. |
| IMLOG2 Function | Base-2 logarithm of a given complex number. |
| IMPOWER Function | Complex number raised to a given power. |
| IMPRODUCT Function | Product of one or more complex numbers. |
| IMREAL Function | Real coefficient of a given complex number. |
| IMSEC Function | Secant of a given complex number. |
| IMSECH Function | Hyperbolic secant of a given complex number. |
| IMSIN Function | Sine of a given complex number. |
| IMSINH Function | Hyperbolic sine of a given complex number. |
| IMSQRT Function | Square root of a given complex number. |
| IMSUB Function | Difference between two specified complex numbers. |
| IMSUM Function | Sum of the given complex numbers. |
| IMTAN Function | Tangent of a given complex number. |
| OCT2BIN Function | From octal number to binary. |
| OCT2DEC Function | From octal number to decimal. |
| OCT2HEX Function | From octal number to hexadecimal. |