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 base2 logarithm of a complex number in x + yi or x + yj text format  =IMLOG2(inumberinumber [required]: A complex number for which you want the base2 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]) 

Created by admin on 2/9/2021
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy
0 Comments for '(Excel)  List of Excel Engineering Functions with Syntax and Arguments' [post comment in main thread]