By Sections
Other Links
Appendix C: Excel Spreadsheets Engineering Functions List (40)
This web page is an appendix. Find a book or an Engineering website for more.
| Importance | Functions | What it Does |
| Specialized | BESSELI | Returns the modified Bessel function In(x) |
| Specialized | BESSELJ | Returns the Bessel function Jn(x) |
| Specialized | BESSELK | Returns the modified Bessel function Kn(x) |
| Specialized | BESSELY | Returns the Bessel function Yn(x) |
| Specialized | BIN2DEC | Converts a binary number to decimal |
| Specialized | BIN2HEX | Converts a binary number to hexadecimal |
| Specialized | BIN2OCT | Converts a binary number to octal |
| Specialized | COMPLEX | Converts real and imaginary coefficients into a complex number |
| Specialized | CONVERT | Converts a number from one measurement system to another |
| Specialized | DEC2BIN | Converts a decimal number to binary |
| Specialized | DEC2HEX | Converts a decimal number to hexadecimal |
| Specialized | DEC2OCT | Converts a decimal number to octal |
| Specialized | DELTA | Tests whether two values are equal |
| Specialized | ERF | Returns the error function |
| Specialized | ERFC | Returns the complementary error function |
| Specialized | FACTDOUBLE | Returns the double factorial of a number |
| Specialized | GESTEP | Tests whether a number is greater than a threshold value |
| Specialized | HEX2BIN | Converts a hexadecimal number to binary |
| Specialized | HEX2DEC | Converts a hexadecimal number to decimal |
| Specialized | HEX2OCT | Converts a hexadecimal number to octal |
| Specialized | IMABS | Returns the absolute value (modulus) of a complex number |
| Specialized | IMAGINARY | Returns the imaginary coefficient of a complex number |
| Specialized | IMARGUMENT | Returns the argument theta, an angle expressed in radians |
| Specialized | IMCONJUGAT | Returns the complex conjugate of a complex number |
| Specialized | IMCOS | Returns the cosine of a complex number |
| Specialized | IMDIV | Returns the quotient of two complex numbers |
| Specialized | IMEXP | Returns the exponential of a complex number |
| Specialized | IMLN | Returns the natural logarithm of a complex number |
| Specialized | IMLOG10 | Returns the base-10 logarithm of a complex number |
| Specialized | IMLOG2 | Returns the base-2 logarithm of a complex number |
| Specialized | IMPOWER | Returns a complex number raised to an integer power |
| Specialized | IMPRODUCT | Returns the product of two complex numbers |
| Specialized | IMREAL | Returns the real coefficient of a complex number |
| Specialized | IMSIN | Returns the sine of a complex number |
| Specialized | IMSQRT | Returns the square root of a complex number |
| Specialized | IMSUB | Returns the difference between two complex numbers |
| Specialized | IMSUM | Returns the sum of complex numbers |
| Specialized | OCT2BIN | Converts an octal number to binary |
| Specialized | OCT2DEC | Converts an octal number to decimal |
| Specialized | OCT2HEX | Converts an octal number to hexadecimal |