Excel Engineering Functions: Complete List with Examples
TL;DR: Excel has 54 built-in engineering functions grouped into seven categories unit conversion, base conversion, complex numbers, Bessel functions, the error function, bitwise operations, and value testing. They power everyday engineering tasks like converting meters to miles (CONVERT), adding complex impedances (IMSUM), or converting decimal to hexadecimal (DEC2HEX). In Excel 2010 and later including Microsoft 365, Excel for the web, and Mac they work out of the box with no add-in required.
Excel engineering functions are built-in functions designed to perform specialized technical calculations converting between units and number bases, working with complex numbers, evaluating Bessel and error functions, and running bitwise operations. They sit in their own category inside Excel’s function library and are used heavily by electrical, mechanical, civil, and aerospace engineers, as well as physics and math students.
This guide covers all 54 functions grouped by category, the exact syntax for each, worked examples you can copy into a worksheet, common errors and how to fix them, and a free downloadable PDF cheat sheet.
What Are Excel Engineering Functions?
Excel engineering functions are a dedicated group of worksheet functions that handle calculations common in engineering and applied science. Rather than building these formulas manually, you call a single function for example, =CONVERT(100,”m”,”ft”) to turn 100 meters into feet, or =COMPLEX(3,4) to create the complex number 3+4i.
They fall into seven groups:
- Unit conversion: convert between measurement systems (meters to miles, Celsius to Fahrenheit).
- Base conversion: convert numbers between binary, octal, decimal, and hexadecimal.
- Complex number functions: create and manipulate complex numbers (the IM… family).
- Bessel functions: evaluate Bessel functions used in wave, heat, and vibration problems.
- Error functions: evaluate the Gauss error function and its complement.
- Bitwise functions: perform bit-level AND, OR, XOR, and shift operations.
- Value-testing functions: compare numbers against each other or a threshold.
Most of these functions live under the Formulas → More Functions → Engineering menu in the Excel ribbon.
How to Enable Engineering Functions (Analysis ToolPak)
In Excel 2010 and later (including Microsoft 365, Mac, and Excel for the web) the engineering functions are built in you can type them directly with no setup.
In Excel 2007 and earlier, they were part of the Analysis ToolPak add-in. If a function returns #NAME? in an old version, enable the ToolPak:
- Click File → Options (in Excel 2007, click the Office button → Excel Options).
- Select Add-ins from the left menu.
- In the Manage drop-down at the bottom, choose Excel Add-ins and click Go….
- Tick Analysis ToolPak and click OK.
Once enabled, the functions become available immediately.
Excel Engineering Functions by Category
The tables below list every engineering function, its syntax, and what it does. Functions marked (2013) were introduced in Excel 2013.
Unit Conversion
| Function | Syntax | Description |
|---|---|---|
| CONVERT | =CONVERT(number, from_unit, to_unit) | Converts a number from one measurement system to another |
Base Conversion (Binary, Octal, Decimal, Hex)
| Function | Syntax | Description |
| BIN2DEC | =BIN2DEC(number) | Converts a binary number to decimal |
| BIN2HEX | =BIN2HEX(number, [places]) | Converts a binary number to hexadecimal |
| BIN2OCT | =BIN2OCT(number, [places]) | Converts a binary number to octal |
| DEC2BIN | =DEC2BIN(number, [places]) | Converts a decimal number to binary |
| DEC2HEX | =DEC2HEX(number, [places]) | Converts a decimal number to hexadecimal |
| DEC2OCT | =DEC2OCT(number, [places]) | Converts a decimal number to octal |
| HEX2BIN | =HEX2BIN(number, [places]) | Converts a hexadecimal number to binary |
| HEX2DEC | =HEX2DEC(number) | Converts a hexadecimal number to decimal |
| HEX2OCT | =HEX2OCT(number, [places]) | Converts a hexadecimal number to octal |
| OCT2BIN | =OCT2BIN(number, [places]) | Converts an octal number to binary |
| OCT2DEC | =OCT2DEC(number) | Converts an octal number to decimal |
| OCT2HEX | =OCT2HEX(number, [places]) | Converts an octal number to hexadecimal |
Complex Number Functions
| Function | Syntax | Description |
| COMPLEX | =COMPLEX(real_num, i_num, [suffix]) | Converts real and imaginary coefficients into a complex number |
| IMABS | =IMABS(inumber) | Returns the absolute value (modulus) of a complex number |
| IMAGINARY | =IMAGINARY(inumber) | Returns the imaginary coefficient of a complex number |
| IMARGUMENT | =IMARGUMENT(inumber) | Returns the argument θ (angle in radians) of a complex number |
| IMCONJUGATE | =IMCONJUGATE(inumber) | Returns the complex conjugate of a complex number |
| IMCOS | =IMCOS(inumber) | Returns the cosine of a complex number |
| IMCOSH | =IMCOSH(inumber) | Returns the hyperbolic cosine of a complex number (2013) |
| IMCOT | =IMCOT(inumber) | Returns the cotangent of a complex number (2013) |
| IMCSC | =IMCSC(inumber) | Returns the cosecant of a complex number (2013) |
| IMCSCH | =IMCSCH(inumber) | Returns the hyperbolic cosecant of a complex number (2013) |
| IMDIV | =IMDIV(inumber1, inumber2) | Returns the quotient of two complex numbers |
| IMEXP | =IMEXP(inumber) | Returns the exponential of a complex number |
| IMLN | =IMLN(inumber) | Returns the natural logarithm of a complex number |
| IMLOG10 | =IMLOG10(inumber) | Returns the base 10 logarithm of a complex number |
| IMLOG2 | =IMLOG2(inumber) | Returns the base 2 logarithm of a complex number |
| IMPOWER | =IMPOWER(inumber, number) | Returns a complex number raised to a power |
| IMPRODUCT | =IMPRODUCT(inumber1, [inumber2], …) | Returns the product of 2 to 255 complex numbers |
| IMREAL | =IMREAL(inumber) | Returns the real coefficient of a complex number |
| IMSEC | =IMSEC(inumber) | Returns the secant of a complex number (2013) |
| IMSECH | =IMSECH(inumber) | Returns the hyperbolic secant of a complex number (2013) |
| IMSIN | =IMSIN(inumber) | Returns the sine of a complex number |
| IMSINH | =IMSINH(inumber) | Returns the hyperbolic sine of a complex number (2013) |
| IMSQRT | =IMSQRT(inumber) | Returns the square root of a complex number |
| IMSUB | =IMSUB(inumber1, inumber2) | Returns the difference between two complex numbers |
| IMSUM | =IMSUM(inumber1, [inumber2], …) | Returns the sum of complex numbers |
| IMTAN | =IMTAN(inumber) | Returns the tangent of a complex number (2013) |
Bessel Functions
| Function | Syntax | Description |
| BESSELI | =BESSELI(X, N) | Returns the modified Bessel function Iₙ(x) |
| BESSELJ | =BESSELJ(X, N) | Returns the Bessel function Jₙ(x) |
| BESSELK | =BESSELK(X, N) | Returns the modified Bessel function Kₙ(x) |
| BESSELY | =BESSELY(X, N) | Returns the Bessel function Yₙ(x) |
Error Functions
| Function | Syntax | Description |
| ERF | =ERF(lower_limit, [upper_limit]) | Returns the error function integrated between the limits |
| ERF.PRECISE | =ERF.PRECISE(x) | Returns the error function integrated between 0 and x (2010) |
| ERFC | =ERFC(x) | Returns the complementary error function |
| ERFC.PRECISE | =ERFC.PRECISE(x) | Returns the complementary error function between x and infinity (2010) |
Bitwise Functions
| Function | Syntax | Description |
| BITAND | =BITAND(number1, number2) | Returns a bitwise ‘AND’ of two numbers (2013) |
| BITOR | =BITOR(number1, number2) | Returns a bitwise ‘OR’ of two numbers (2013) |
| BITXOR | =BITXOR(number1, number2) | Returns a bitwise ‘Exclusive OR’ of two numbers (2013) |
| BITLSHIFT | =BITLSHIFT(number, shift_amount) | Shifts a number left by a number of bits (2013) |
| BITRSHIFT | =BITRSHIFT(number, shift_amount) | Shifts a number right by a number of bits (2013) |
Value-Testing Functions
| Function | Syntax | Description |
| DELTA | =DELTA(number1, [number2]) | Tests whether two numbers are equal (returns 1 or 0) |
| GESTEP | =GESTEP(number, [step]) | Tests whether a number is ≥ a threshold (returns 1 or 0) |
Download the free Excel Engineering Functions PDF cheat sheet →
Worked Examples Engineers Actually Use
Example 1 – Convert meters to miles with CONVERT
A civil engineer needs to express a 1,000-meter alignment in miles.
=CONVERT(1000, “m”, “mi”)
Result: 0.621371 — so 1,000 meters equals about 0.62 miles. The CONVERT function recognizes dozens of unit codes across distance, weight, temperature, pressure, energy, and time. For temperature, use =CONVERT(100,”C”,”F”) to get 212 (100 °C in Fahrenheit).
Example 2 – Add two complex impedances with IMSUM
In AC circuit analysis, impedances add as complex numbers. To add 3+4i and 5+2i:
=IMSUM(COMPLEX(3,4), COMPLEX(5,2))
Result: 8+6i. Use =IMABS(“8+6i”) to get the magnitude (10) and =IMARGUMENT(“8+6i”) for the phase angle in radians.
Example 3 – Convert decimal to hexadecimal with DEC2HEX
An embedded-systems engineer needs the hex value of decimal 255 for a register:
=DEC2HEX(255)
Result: FF. To force a fixed width, add the optional places argument: =DEC2HEX(255,4) returns 00FF.
Example 4 – Evaluate the error function with ERF
The error function appears in heat conduction and probability. To find ERF at 1:
=ERF(1)
Result: 0.842701. To integrate between two limits, supply both: =ERF(0.5,1).
Example 5 – Compare a measured value to a threshold with GESTEP
A quality engineer flags any reading at or above a tolerance of 5.0:
=GESTEP(5.2, 5)
Result: 1 (the value meets or exceeds the threshold). A reading of 4.8 returns 0. Combine with SUM across a column to count how many parts pass.
Example 6 – Bitwise AND for control flags with BITAND
To check whether bit patterns overlap common in PLC and microcontroller logic:
=BITAND(13, 25)
Result: 9. In binary, 1101 AND 11001 = 01001, which is 9 in decimal.
Frequently Asked Questions
What are engineering functions in Excel?
Engineering functions are 54 built-in Excel functions for specialized technical calculations, including unit conversion, base conversion (binary/octal/decimal/hex), complex-number arithmetic, Bessel functions, the error function, and bitwise operations.
How do I enable engineering functions in Excel?
In Excel 2010 and later they are built in and need no setup. In Excel 2007 and earlier, enable the Analysis ToolPak via File → Options → Add-ins → Manage: Excel Add-ins → Go → Analysis ToolPak → OK.
Do I still need the Analysis ToolPak in Excel 365?
No. In Microsoft 365, Excel 2010–2024, Excel for the web, and Excel for Mac, the engineering functions are native and work without any add-in.
What is the CONVERT function used for?
CONVERT changes a value from one unit of measurement to another for example meters to miles, pounds to kilograms, or Celsius to Fahrenheit using built-in unit codes.
How do complex-number functions work in Excel?
You create a complex number with COMPLEX(real, imaginary) and then operate on it with the IM… family, such as IMSUM, IMSUB, IMPRODUCT, IMABS, and IMARGUMENT. Complex values are stored as text like “3+4i”.
What are Bessel functions used for in engineering?
Bessel functions (BESSELJ, BESSELY, BESSELI, BESSELK) describe wave propagation, heat conduction in cylinders, vibration of circular membranes, and signal processing problems.
What is the difference between ERF and ERFC?
ERF returns the Gauss error function value; ERFC returns the complementary error function, equal to 1 − ERF(x). Both appear in heat transfer, diffusion, and probability.
Why am I getting a #NUM! or #VALUE! error with engineering functions?
#NUM! usually means an input is out of the function’s valid range; #VALUE! usually means an argument is the wrong type for example text where a number is expected, or an incorrectly formatted complex number.
Can Excel convert units automatically?
Yes. The CONVERT function converts between units of distance, weight, temperature, pressure, energy, power, time, and more using standard unit abbreviations.
Are engineering functions available in Excel for the web and Mac?
Yes. All 54 engineering functions work in Excel for the web, Excel for Mac, and Microsoft 365, in addition to desktop Excel on Windows.
Final Thoughts
Excel’s 54 engineering functions cover nearly every specialized calculation an engineer needs day to day converting units and number bases, working with complex numbers, and evaluating Bessel and error functions. The ones you’ll reach for most are CONVERT, the IM… complex family, DEC2HEX/HEX2DEC, and ERF. Since Excel 2010, they all work natively with no add-in, across Windows, Mac, and the web.
Bookmark this page as your quick reference, grab the free PDF cheat sheet to keep the full list handy offline, and pair these with Excel’s Math & Trig functions whenever you need standard real-number calculations alongside them.
READ NEXT:
