MacOSShortcutsWindows

55 Excel Engineering Functions

For Windows & Mac

Excel Engineering Functions, in other words, are the functions that perform calculations used in engineering applications. The Engineering Formulas will mostly be related to Bessel Functions, Complex numbers, or converting between different bases. Excel is used for everything in engineering irrespective of the industry.

Download Excel Engineering Functions PDF

Combining equations and tables will create powerful engine models. The below list of Excel Engineering Formulas will make the life of engineers a little easier and more confident. Download the Excel Engineering Formulas list in the form of a PDF.

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 function and Statistical Function are used in combination with Engineering Formulas. Think again if you are using Excel for engineering calculations. I know Excel is a convenient choice but would prefer PTC Mathcad. PTC Mathcad is purposely built for engineering calculation. Have the leverage to use the respective strengths of Excel and PTC Mathcad together.

FAQs

What are Excel engineering functions?

Excel engineering functions are built-in mathematical and statistical functions designed specifically for engineering and scientific calculations. These functions can perform various calculations commonly used in fields such as civil engineering, mechanical engineering, electrical engineering, and more.

How do I use engineering functions in Excel?

To use engineering formulas in Excel, you can enter the function name along with its arguments in a cell or formula. For example, to use the Bessel function, you can enter =BESSELJ(A1, B1) in a cell, where A1 and B1 are the arguments for the function. The specific syntax and arguments for each engineering formulas may vary, so it's important to refer to the documentation or help files for accurate usage.

What are some common engineering formulas in Excel?

Excel offers several engineering formulas. Some common examples include BESSELJ for Bessel functions, BIN2DEC for converting binary to decimal, DEC2BIN for converting decimal to binary, IMREAL for returning the real part of a complex number, IMAGINARY for returning the imaginary part of a complex number, and more. The available engineering formulas depend on the version of Excel you are using.

READ NEXT:

Back to top button