This reference table lists all officially documented Engineering Functions. It is based on the Excel Help documentation and linked in each row when clicking on the function name. Export the table and/or display additional columns via the symbols to the top right of the table. Please report errors or inconsistencies via the comment function at the bottom of this page. Also check the main table with List of all Excel Functions.
| # | Excel Function | Description | Syntax with Arguments | Syntax only | Arguments only |
|---|---|---|---|---|---|
| 1 | BESSELI | Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments | =BESSELI(xx [required]: The value at which to evaluate the function., nn [required]: The order of the Bessel function.) | =BESSELI(x, n) |
|
| 2 | BESSELJ | Returns the Bessel function | =BESSELJ(xx [required]: The value at which to evaluate the function., nn [required]: The order of the Bessel function.) | =BESSELJ(x, n) |
|
| 3 | BESSELK | Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments | =BESSELK(xx [required]: The value at which to evaluate the function., nn [required]: The order of the function.) | =BESSELK(x, n) |
|
| 4 | BESSELY | Returns the Bessel function, which is also called the Weber function or the Neumann function | =BESSELY(xx [required]: The value at which to evaluate the function., nn [required]: The order of the function.) | =BESSELY(x, n) |
|
| 5 | BIN2DEC | Converts a binary number to decimal | =BIN2DEC(numbernumber [required]: The binary number you want to convert. ) | =BIN2DEC(number) |
|
| 6 | BIN2HEX | Converts a binary number to hexadecimal | =BIN2HEX(numbernumber [required]: The binary number you want to convert., [placesplaces [optional]: The number of characters to use.]) | =BIN2HEX(number, [places]) |
|
| 7 | BIN2OCT | Converts a binary number to octal | =BIN2OCT(numbernumber [required]: The binary number you want to convert., [placesplaces [optional]: The number of characters to use.]) | =BIN2OCT(number, [places]) |
|
| 8 | BITAND | Returns a bitwise 'AND' of two numbers | =BITAND(number1number1 [required]: Must be in decimal form and greater than or equal to 0., number2number2 [required]: Must be in decimal form and greater than or equal to 0.) | =BITAND(number1, number2) |
|
| 9 | BITLSHIFT | Returns a number shifted left by the specified number of bits | =BITLSHIFT(numbernumber [required]: Number must be an integer greater than or equal to 0., shift_amountshift_amount [required]: Shift_amount must be an integer.) | =BITLSHIFT(number, shift_amount) |
|
| 10 | BITOR | Returns a bitwise 'OR' of two numbers | =BITOR(number1number1 [required]: Must be in decimal form and greater than or equal to 0., number2number2 [required]: Must be in decimal form and greater than or equal to 0.) | =BITOR(number1, number2) |
|
| 11 | BITRSHIFT | Returns a number shifted right by the specified number of bits | =BITRSHIFT(numbernumber [required]: Must be an integer greater than or equal to 0., shift_amountshift_amount [required]: Must be an integer.) | =BITRSHIFT(number, shift_amount) |
|
| 12 | BITXOR | Returns a bitwise 'XOR' of two numbers | =BITXOR(number1number1 [required]: Must be greater than or equal to 0., number2number2 [required]: Must be greater than or equal to 0.) | =BITXOR(number1, number2) |
|
| 13 | COMPLEX | Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj | =COMPLEX(real_numreal_num [required]: The real coefficient of the complex number., i_numi_num [required]: The imaginary coefficient of the complex number., [suffixsuffix [optional]: The suffix for the imaginary component of the complex number.]) | =COMPLEX(real_num, i_num, [suffix]) |
|
| 14 | CONVERT | Converts a number from one measurement system to another | =CONVERT(numbernumber [required]: Input value., from_unitfrom_unit [required]: Input unit., to_unitto_unit [required]: Output unit.) | =CONVERT(number, from_unit, to_unit) |
|
| 15 | DEC2BIN | Converts a decimal number to binary | =DEC2BIN(numbernumber [required]: The decimal integer you want to convert., [placesplaces [optional]: The number of characters to use.]) | =DEC2BIN(number, [places]) |
|
| 16 | DEC2HEX | Converts a decimal number to hexadecimal | =DEC2HEX(numbernumber [required]: The decimal integer you want to convert., [placesplaces [optional]: The number of characters to use.]) | =DEC2HEX(number, [places]) |
|
| 17 | DEC2OCT | Converts a decimal number to octal | =DEC2OCT(numbernumber [required]: The decimal integer you want to convert., [placesplaces [optional]: The number of characters to use.]) | =DEC2OCT(number, [places]) |
|
| 18 | DELTA | Tests whether two values are equal | =DELTA(number1number1 [required]: The first number., [number2number2 [optional]: Additional numbers]) | =DELTA(number1, [number2]) |
|
| 19 | ERF | Returns the error function integrated between lower_limit and upper_limit | =ERF(lower_limitlower_limit [required]: The lower bound for integrating ERF., [upper_limitupper_limit [optional]: The upper bound for integrating ERF.]) | =ERF(lower_limit, [upper_limit]) |
|
| 20 | ERF.PRECISE | Returns the error function | =ERF.PRECISE(xx [required]: The lower bound for integrating ERF.) | =ERF.PRECISE(x) |
|
| 21 | ERFC | Returns the complementary ERF function integrated between x and infinity | =ERFC(xx [required]: The lower bound for integrating ERFC.) | =ERFC(x) |
|
| 22 | ERFC.PRECISE | Returns the complementary ERF function integrated between x and infinity | =ERFC.PRECISE(xx [required]: The lower bound for integrating ERFC.) | =ERFC.PRECISE(x) |
|
| 23 | GESTEP | Returns 1 if number ? step; returns 0 (zero) otherwise | =GESTEP(numbernumber [required]: The value to test against step., [stepstep [optional]: The threshold value.]) | =GESTEP(number, [step]) |
|
| 24 | HEX2BIN | Converts a hexadecimal number to binary | =HEX2BIN(numbernumber [required]: The hexadecimal number you want to convert., [placesplaces [optional]: The number of characters to use.]) | =HEX2BIN(number, [places]) |
|
| 25 | HEX2DEC | Converts a hexadecimal number to decimal | =HEX2DEC(numbernumber [required]: The hexadecimal number you want to convert.) | =HEX2DEC(number) |
|
| 26 | HEX2OCT | Converts a hexadecimal number to octal | =HEX2OCT(numbernumber [required]: The hexadecimal number you want to convert., [placesplaces [optional]: The number of characters to use.]) | =HEX2OCT(number, [places]) |
|
| 27 | IMABS | Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format | =IMABS(inumberinumber [required]: A complex number for which you want the absolute value.) | =IMABS(inumber) |
|
| 28 | IMAGINARY | Returns the imaginary coefficient of a complex number in x + yi or x + yj text format | =IMAGINARY(inumberinumber [required]: A complex number for which you want the imaginary coefficient.) | =IMAGINARY(inumber) |
|
| 29 | IMARGUMENT | Returns the imaginary coefficient of a complex number in x + yi or x + yj text format | =IMARGUMENT(inumberinumber [required]: A complex number for which you want the argument.) | =IMARGUMENT(inumber) |
|
| 30 | IMCONJUGATE | Returns the complex conjugate of a complex number in x + yi or x + yj text format | =IMCONJUGATE(inumberinumber [required]: A complex number for which you want the conjugate.) | =IMCONJUGATE(inumber) |
|
| 31 | IMCOS | Returns the cosine of a complex number in x + yi or x + yj text format | =IMCOS(inumberinumber [required]: A complex number for which you want the cosine.) | =IMCOS(inumber) |
|
| 32 | IMCOSH | Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format | =IMCOSH(inumberinumber [required]: A complex number for which you want the hyperbolic cosine.) | =IMCOSH(inumber) |
|
| 33 | IMCOT | Returns the cotangent of a complex number in x+yi or x+yj text format | =IMCOT(inumberinumber [required]: A complex number for which you want the cotangent.) | =IMCOT(inumber) |
|
| 34 | IMCSC | Returns the cosecant of a complex number in x+yi or x+yj text format | =IMCSC(inumberinumber [required]: A complex number for which you want the cosecant.) | =IMCSC(inumber) |
|
| 35 | IMCSCH | Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format | =IMCSCH(inumberinumber [required]: A complex number for which you want the hyperbolic cosecant.) | =IMCSCH(inumber) |
|
| 36 | IMDIV | Returns the quotient of two complex numbers in x + yi or x + yj text format | =IMDIV(inumber1inumber1 [required]: The complex numerator or dividend., inumber2inumber2 [required]: The complex denominator or divisor.) | =IMDIV(inumber1, inumber2) |
|
| 37 | IMEXP | Returns the exponential of a complex number in x + yi or x + yj text format | =IMEXP(inumberinumber [required]: A complex number for which you want the exponential.) | =IMEXP(inumber) |
|
| 38 | IMLN | Returns the natural logarithm of a complex number in x + yi or x + yj text format | =IMLN(inumberinumber [required]: A complex number for which you want the natural logarithm.) | =IMLN(inumber) |
|
| 39 | IMLOG10 | Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format | =IMLOG10(inumberinumber [required]: A complex number for which you want the common logarithm.) | =IMLOG10(inumber) |
|
| 40 | IMLOG2 | Returns the base-2 logarithm of a complex number in x + yi or x + yj text format | =IMLOG2(inumberinumber [required]: A complex number for which you want the base-2 logarithm.) | =IMLOG2(inumber) |
|
| 41 | IMPOWER | Returns a complex number in x + yi or x + yj text format raised to a power | =IMPOWER(inumberinumber [required]: A complex number you want to raise to a power., numbernumber [required]: The power to which you want to raise the complex number.) | =IMPOWER(inumber, number) |
|
| 42 | IMPRODUCT | Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format | =IMPRODUCT(inumber1inumber1 [optional]: Additional complex numbers, [inumber2inumber2 [required]: A complex number to use improduct function on], ...) | =IMPRODUCT(inumber1, [inumber2], ...) |
|
| 43 | IMREAL | Returns the real coefficient of a complex number in x + yi or x + yj text format | =IMREAL(inumberinumber [required]: A complex number for which you want the real coefficient.) | =IMREAL(inumber) |
|
| 44 | IMSEC | Returns the secant of a complex number in x+yi or x+yj text format | =IMSEC(inumberinumber [required]: A complex number for which you want the secant.) | =IMSEC(inumber) |
|
| 45 | IMSECH | Returns the hyperbolic secant of a complex number in x+yi or x+yj text format | =IMSECH(inumberinumber [required]: A complex number for which you want the hyperbolic secant.) | =IMSECH(inumber) |
|
| 46 | IMSIN | Returns the sine of a complex number in x + yi or x + yj text format | =IMSIN(inumberinumber [required]: A complex number for which you want the sine.) | =IMSIN(inumber) |
|
| 47 | IMSINH | Function returns the hyperbolic sine of a complex number in x+yi or x+yj text format | =IMSINH(inumberinumber [required]: A complex number for which you want the hyperbolic sine.) | =IMSINH(inumber) |
|
| 48 | IMSQRT | Returns the square root of a complex number in x + yi or x + yj text format | =IMSQRT(inumberinumber [required]: A complex number for which you want the square root.) | =IMSQRT(inumber) |
|
| 49 | IMSUB | Returns the difference of two complex numbers in x + yi or x + yj text format | =IMSUB(inumber1inumber1 [required]: The complex number from which to subtract inumber2., inumber2inumber2 [required]: The complex number to subtract from inumber1.) | =IMSUB(inumber1, inumber2) |
|
| 50 | IMSUM | Returns the sum of two or more complex numbers in x + yi or x + yj text format | =IMSUM(inumber1inumber1 [required]: The complex number you want to add., [inumber2inumber2 [optional]: Additional optional complex numbers.], ...) | =IMSUM(inumber1, [inumber2], ...) |
|
| 51 | IMTAN | Returns the tangent of a complex number in x+yi or x+yj text format | =IMTAN(inumberinumber [required]: A complex number for which you want the tangent.) | =IMTAN(inumber) |
|
| 52 | OCT2BIN | Converts an octal number to binary | =OCT2BIN(numbernumber [required]: The octal number you want to convert., [placesplaces [optional]: The number of characters to use.]) | =OCT2BIN(number, [places]) |
|
| 53 | OCT2DEC | Converts an octal number to decimal | =OCT2DEC(numbernumber [required]: The octal number you want to convert.) | =OCT2DEC(number) |
|
| 54 | OCT2HEX | Converts an octal number to hexadecimal | =OCT2HEX(numbernumber [required]: The octal number you want to convert., [placesplaces [optional]: The number of characters to use.]) | =OCT2HEX(number, [places]) |
|
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy