Engineering functions
Engineering functions convert units and number bases, work with complex numbers and do bitwise math. Most people need only a few, like CONVERT.
54 functions in this category.
Start here
- DEC2BIN
Converts a decimal number to binary. Seen in IT, networking and low-level data work.
- HEX2BIN
Converts a hexadecimal number to binary. Seen in IT, networking and low-level data work.
- BIN2DEC
Converts a binary number to decimal. Seen in IT, networking and low-level data work.
- CONVERT
Converts between units of length, weight, time, temperature, volume and more. A quick way to avoid hard-coded conversion factors.
- DEC2HEX
Converts a decimal number to hexadecimal. Seen in IT, networking and low-level data work.
- HEX2DEC
Converts a hexadecimal number to decimal. Seen in IT, networking and low-level data work.
All engineering functions
| Function | What it does | Level | Since | Spills? |
|---|---|---|---|---|
BESSELI | Evaluates the modified Bessel function of the first kind. It shows up in physics and signal-processing models, rarely in business work. | Expert | 2007 or earlier | No |
BESSELJ | Evaluates the ordinary Bessel function of the first kind, used for wave and vibration problems. | Expert | 2007 or earlier | No |
BESSELK | Evaluates the modified Bessel function of the second kind, found in heat-flow and field problems. | Expert | 2007 or earlier | No |
BESSELY | Evaluates the Bessel function of the second kind, used alongside BESSELJ in wave problems. | Expert | 2007 or earlier | No |
BIN2DEC | Converts a binary number to decimal. Seen in IT, networking and low-level data work. | Intermediate | 2007 or earlier | No |
BIN2HEX | Converts a binary number to hexadecimal. Seen in IT, networking and low-level data work. | Expert | 2007 or earlier | No |
BIN2OCT | Converts a binary number to octal. Seen in IT, networking and low-level data work. | Expert | 2007 or earlier | No |
BITAND | Compares two numbers bit by bit and keeps only bits that are on in both. Used to test flags packed into one number. | Expert | 2013 | No |
BITLSHIFT | Shifts the bits of a number left, which multiplies by powers of two. | Expert | 2013 | No |
BITOR | Compares two numbers bit by bit and keeps bits that are on in either. | Expert | 2013 | No |
BITRSHIFT | Shifts the bits of a number right, which divides by powers of two and drops remainders. | Expert | 2013 | No |
BITXOR | Compares two numbers bit by bit and keeps bits that differ between them. | Expert | 2013 | No |
COMPLEX | Builds a complex number from its two parts. Used in electrical and signal engineering. | Expert | 2007 or earlier | No |
CONVERT | Converts between units of length, weight, time, temperature, volume and more. A quick way to avoid hard-coded conversion factors. | Intermediate | 2007 or earlier | No |
DEC2BIN | Converts a decimal number to binary. Seen in IT, networking and low-level data work. | Intermediate | 2007 or earlier | No |
DEC2HEX | Converts a decimal number to hexadecimal. Seen in IT, networking and low-level data work. | Intermediate | 2007 or earlier | No |
DEC2OCT | Converts a decimal number to octal. Seen in IT, networking and low-level data work. | Expert | 2007 or earlier | No |
DELTA | Tests whether two numbers are equal and returns 1 or 0, which can be summed to count matches. | Expert | 2007 or earlier | No |
ERF | Computes the Gaussian error function, used in probability and diffusion calculations. Most users want NORM.S.DIST instead. | Expert | 2007 or earlier | No |
ERF.PRECISE | A single-argument error function with improved accuracy over older versions of ERF. | Expert | 2010 | No |
ERFC | Gives the complement of the error function, accurate for large x where 1-ERF loses precision. | Expert | 2007 or earlier | No |
ERFC.PRECISE | Same result as ERFC, introduced as the modern named version. | Expert | 2010 | No |
GESTEP | A step function that returns 1 when a value reaches a threshold. Can count values over a limit via SUMPRODUCT. | Expert | 2007 or earlier | No |
HEX2BIN | Converts a hexadecimal number to binary. Seen in IT, networking and low-level data work. | Expert | 2007 or earlier | No |
HEX2DEC | Converts a hexadecimal number to decimal. Seen in IT, networking and low-level data work. | Intermediate | 2007 or earlier | No |
HEX2OCT | Converts a hexadecimal number to octal. Seen in IT, networking and low-level data work. | Expert | 2007 or earlier | No |
IMABS | Gives the distance of a complex number from zero. Used to get the magnitude of a signal. | Expert | 2007 or earlier | No |
IMAGINARY | Returns the imaginary part of a complex number. | Expert | 2007 or earlier | No |
IMARGUMENT | Returns the angle (theta) of the complex number in radians. | Expert | 2007 or earlier | No |
IMCONJUGATE | Flips the sign of the imaginary part. | Expert | 2007 or earlier | No |
IMCOS | Returns the cosine of a complex number. | Expert | 2007 or earlier | No |
IMCOSH | Returns the hyperbolic cosine of a complex number. | Expert | 2013 | No |
IMCOT | Returns the cotangent of a complex number. | Expert | 2013 | No |
IMCSC | Returns the cosecant of a complex number. | Expert | 2013 | No |
IMCSCH | Returns the hyperbolic cosecant of a complex number. | Expert | 2013 | No |
IMDIV | Divides one complex number by another. | Expert | 2007 or earlier | No |
IMEXP | Returns e raised to a complex power. | Expert | 2007 or earlier | No |
IMLN | Returns the natural logarithm of a complex number. | Expert | 2007 or earlier | No |
IMLOG10 | Returns the base-10 logarithm of a complex number. | Expert | 2007 or earlier | No |
IMLOG2 | Returns the base-2 logarithm of a complex number. | Expert | 2007 or earlier | No |
IMPOWER | Raises a complex number to a power. | Expert | 2007 or earlier | No |
IMPRODUCT | Multiplies complex numbers together. | Expert | 2007 or earlier | No |
IMREAL | Returns the real part of a complex number. | Expert | 2007 or earlier | No |
IMSEC | Returns the secant of a complex number. | Expert | 2013 | No |
IMSECH | Returns the hyperbolic secant of a complex number. | Expert | 2013 | No |
IMSIN | Returns the sine of a complex number. | Expert | 2007 or earlier | No |
IMSINH | Returns the hyperbolic sine of a complex number. | Expert | 2013 | No |
IMSQRT | Returns the square root of a complex number. | Expert | 2007 or earlier | No |
IMSUB | Subtracts one complex number from another. | Expert | 2007 or earlier | No |
IMSUM | Adds complex numbers together. | Expert | 2007 or earlier | No |
IMTAN | Returns the tangent of a complex number. | Expert | 2013 | No |
OCT2BIN | Converts a octal number to binary. Seen in IT, networking and low-level data work. | Expert | 2007 or earlier | No |
OCT2DEC | Converts a octal number to decimal. Seen in IT, networking and low-level data work. | Expert | 2007 or earlier | No |
OCT2HEX | Converts a octal number to hexadecimal. Seen in IT, networking and low-level data work. | Expert | 2007 or earlier | No |
Other categories
- Lookup and reference functions
43 functions
- Math and trig functions
80 functions
- Logical functions
19 functions
- Text functions
48 functions
- Date and time functions
25 functions
- Statistical functions
111 functions
- Financial functions
56 functions
- Information functions
21 functions
- Database functions
12 functions
- Web functions
3 functions
- Compatibility functions
41 functions
- Cube functions
7 functions
- Add-in and automation functions
5 functions