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

### Devil

Hello, my name is Pratik, and I am the founder of Tutorial Tactic. Mistakes are essential for learning, and Tutorial Tactic is here to help you stand strong, learn even more, and achieve success!