Home › Excel formulas › Engineering functions
Excel Engineering Functions: Full List with Examples
These are all the Excel Engineering functions on Cellgrids. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| BIN2DEC | Converts a binary number to decimal. |
| BIN2HEX | Converts a binary number to hexadecimal. |
| BIN2OCT | Converts a binary number to octal. |
| DEC2BIN | Converts a decimal number to binary. |
| DEC2HEX | Converts a decimal number to hexadecimal. |
| DEC2OCT | Converts a decimal number to octal. |
| HEX2BIN | Converts a hexadecimal number to binary. |
| HEX2DEC | Converts a hexadecimal number to decimal. |
| HEX2OCT | Converts a hexadecimal number to octal. |
| OCT2BIN | Converts an octal number to binary. |
| OCT2DEC | Converts an octal number to decimal. |
| OCT2HEX | Converts an octal number to hexadecimal. |
| COMPLEX | Combines real and imaginary parts into a complex number. |
| IMABS | Returns the absolute value of a complex number. |
| IMAGINARY | Returns the imaginary coefficient of a complex number. |
| IMARGUMENT | Returns the angle (argument) of a complex number, in radians. |
| IMCONJUGATE | Returns the complex conjugate of a complex number. |
| IMCOS | Returns the cosine of a complex number. |
| IMCOSH | Returns the hyperbolic cosine of a complex number. |
| IMCOT | Returns the cotangent of a complex number. |
| IMCSC | Returns the cosecant of a complex number. |
| IMCSCH | Returns the hyperbolic cosecant of a complex number. |
| IMDIV | Returns the quotient of two complex numbers. |
| IMEXP | Returns e raised to the power of a complex number. |
| IMLN | Returns the natural logarithm of a complex number. |
| IMLOG10 | Returns the base-10 logarithm of a complex number. |
| IMLOG2 | Returns the base-2 logarithm of a complex number. |
| IMPOWER | Raises a complex number to a given power. |
| IMPRODUCT | Returns the product of complex numbers. |
| IMREAL | Returns the real coefficient of a complex number. |
| IMSEC | Returns the secant of a complex number. |
| IMSECH | Returns the hyperbolic secant of a complex number. |
| IMSIN | Returns the sine of a complex number. |
| IMSINH | Returns the hyperbolic sine of a complex number. |
| IMSQRT | Returns the square root of a complex number. |
| IMSUB | Returns the difference of two complex numbers. |
| IMSUM | Returns the sum of complex numbers. |
| IMTAN | Returns the tangent of a complex number. |
| CONVERT | Converts a number from one measurement unit to another. |
| DELTA | Tests whether two numbers are exactly equal, returning 1 or 0. |
| GESTEP | Tests whether a number is greater than or equal to a threshold. |
| ERF | Returns the error function, used in probability and statistics. |
| ERFC | Returns the complementary error function. |
| BESSELJ | Returns the Bessel function Jn(x). |
| BESSELY | Returns the Bessel function Yn(x). |
| BESSELI | Returns the modified Bessel function In(x). |
| BESSELK | Returns the modified Bessel function Kn(x). |
| ERF.PRECISE | Returns a more precise version of the error function. |
| ERFC.PRECISE | Returns a more precise version of the complementary error function. |
Practice Engineering functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Engineering functions?
Cellgrids lists 49 Excel Engineering functions. Popular ones include BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX. Each has its own page with syntax, arguments and an example.
How can I practice Excel Engineering functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Engineering function should a beginner learn first?
Start with BIN2DEC. Converts a binary number to decimal.