55 Excel Engineering Functions & Formulas
Excel Engineering Functions, in essence, are functions designed to perform calculations tailored for engineering applications. These Engineering Formulas typically involve calculations related to Bessel Functions, complex numbers, or conversions between different bases. Excel is a ubiquitous tool in engineering, utilized across various industries.
By combining equations and tables, engineers can create powerful engine models. The following list of Excel Engineering Formulas aims to make the lives of engineers a bit easier and more confident. You can download the Excel Engineering Formulas list in PDF format.
Most used Engineering Functions Shortcuts
| Excel Engineering Formulas | Formulas Syntax |
|---|---|
| BESSELI | =BESSELI(X, N) |
| BESSELJ | =BESSELJ(X, N) |
| BESSELK | =BESSELK(X, N) |
| BESSELY | =BESSELY(X, N) |
| BIN2DEC | =BIN2DEC(number) |
| BIN2HEX | =BIN2HEX(number, [places]) |
| BIN2OCT | =BIN2OCT(number, [places]) |
| BITAND | =BITAND( number1, number2) |
| BITLSHIFT | =BITLSHIFT(number, shift_amount) |
| BITOR | =BITOR(number1, number2) |
| BITRSHIFT | =BITRSHIFT(number, shift_amount) |
| BITXOR | =BITXOR(number1, number2) |
| COMPLEX | =COMPLEX(real_num, i_num, [suffix]) |
| CONVERT | =CONVERT(number,from_unit,to_unit) |
| DEC2BIN | =DEC2BIN(number, [places]) |
| DEC2HEX | =DEC2HEX(number, [places]) |
| DEC2OCT | =DEC2OCT(number, [places]) |
| DELTA | =DELTA(number1, [number2]) |
| ERF | =ERF(lower_limit,[upper_limit]) |
| ERF.PRECISE | =ERF.PRECISE(x) |
| ERFC | =ERFC(x) |
| ERFC.PRECISE | =ERFC.PRECISE(x) |
| GESTEP | =GESTEP(number, [step]) |
| HEX2BIN | =HEX2BIN(number, [places]) |
| HEX2DEC | =HEX2DEC(number) |
| HEX2OCT | =HEX2OCT(number, [places]) |
| IMABS | =IMABS(inumber) |
| IMAGINARY | =IMAGINARY(inumber) |
| IMARGUMENT | =IMARGUMENT(inumber) |
| IMCONJUGATE | =IMCONJUGATE(inumber) |
| IMCOS | =IMCOS(inumber) |
| IMCOSH | =IMCOSH(inumber) |
| IMCOT | =IMCOT(inumber) |
| IMCSC | =IMCSC(inumber) |
| IMCSCH | =IMCSCH(inumber) |
| IMDIV | =IMDIV(inumber1, inumber2) |
| IMEXP | =IMEXP(inumber) |
| IMLN | =IMLN(inumber) |
| IMLOG10 | =IMLOG10(inumber) |
| IMLOG2 | =IMLOG2(inumber) |
| IMPOWER | =IMPOWER(inumber, number) |
| IMPRODUCT | =IMPRODUCT(inumber1, [inumber2], …) |
| IMREAL | =IMREAL(inumber) |
| IMSEC | =IMSEC(inumber) |
| IMSECH | =IMSECH(inumber) |
| IMSIN | =IMSIN(inumber) |
| IMSINH | =IMSINH(inumber) |
| IMSQRT | =IMSQRT(inumber) |
| IMSUB | =IMSUB(inumber1, inumber2) |
| IMSUM | =IMSUM(inumber1, [inumber2], …) |
| IMTAN | =IMTAN(inumber) |
| OCT2BIN | =OCT2BIN(number, [places]) |
| OCT2DEC | =OCT2DEC(number) |
| OCT2HEX | =OCT2HEX(number, [places]) |
The Math and Statistical Functions are often employed in conjunction with Engineering Formulas. If you’re currently relying on Excel for engineering calculations, it might be worth reconsidering your approach. While Excel is undeniably convenient, I would recommend considering PTC Mathcad instead. PTC Mathcad is specifically designed for engineering calculations, allowing you to leverage the strengths of both Excel and PTC Mathcad together.
READ NEXT:
- 85 HTML Kit Keyboard Shortcuts
- 110 Phoenix Viewer Keyboard Shortcuts
- 30 X Plane Keyboard Shortcuts
- 30 Unreal Engine Keyboard Shortcuts
