List of Excel Engineering Functions with Syntax and Arguments

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 FunctionDescriptionSyntax with ArgumentsSyntax onlyArguments only
1BESSELIReturns 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)
  • x (required): The value at which to evaluate the function.
  • n (required): The order of the Bessel function.
2BESSELJReturns 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)
  • x (required): The value at which to evaluate the function.
  • n (required): The order of the Bessel function.
3BESSELKReturns 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)
  • x (required): The value at which to evaluate the function.
  • n (required): The order of the function.
4BESSELYReturns 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)
  • x (required): The value at which to evaluate the function.
  • n (required): The order of the function.
5BIN2DECConverts a binary number to decimal=BIN2DEC(numbernumber [required]: The binary number you want to convert. )=BIN2DEC(number)
  • number (required): The binary number you want to convert.
6BIN2HEXConverts 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])
  • number (required): The binary number you want to convert.
  • places (optional): The number of characters to use.
7BIN2OCTConverts 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])
  • number (required): The binary number you want to convert.
  • places (optional): The number of characters to use.
8BITANDReturns 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)
  • number1 (required): Must be in decimal form and greater than or equal to 0.
  • number2 (required): Must be in decimal form and greater than or equal to 0.
9BITLSHIFTReturns 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)
  • number (required): Number must be an integer greater than or equal to 0.
  • shift_amount (required): Shift_amount must be an integer.
10BITORReturns 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)
  • number1 (required): Must be in decimal form and greater than or equal to 0.
  • number2 (required): Must be in decimal form and greater than or equal to 0.
11BITRSHIFTReturns 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)
  • number (required): Must be an integer greater than or equal to 0.
  • shift_amount (required): Must be an integer.
12BITXORReturns 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)
  • number1 (required): Must be greater than or equal to 0.
  • number2 (required): Must be greater than or equal to 0.
13COMPLEXConverts 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])
  • real_num (required): The real coefficient of the complex number.
  • i_num (required): The imaginary coefficient of the complex number.
  • suffix (optional): The suffix for the imaginary component of the complex number.
14CONVERTConverts 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)
  • number (required): Input value.
  • from_unit (required): Input unit.
  • to_unit (required): Output unit.
15DEC2BINConverts 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])
  • number (required): The decimal integer you want to convert.
  • places (optional): The number of characters to use.
16DEC2HEXConverts 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])
  • number (required): The decimal integer you want to convert.
  • places (optional): The number of characters to use.
17DEC2OCTConverts 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])
  • number (required): The decimal integer you want to convert.
  • places (optional): The number of characters to use.
18DELTATests whether two values are equal=DELTA(number1number1 [required]: The first number., [number2number2 [optional]: Additional numbers])=DELTA(number1, [number2])
  • number1 (required): The first number.
  • number2 (optional): Additional numbers
19ERFReturns 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])
  • lower_limit (required): The lower bound for integrating ERF.
  • upper_limit (optional): The upper bound for integrating ERF.
20ERF.PRECISEReturns the error function=ERF.PRECISE(xx [required]: The lower bound for integrating ERF.)=ERF.PRECISE(x)
  • x (required): The lower bound for integrating ERF.
21ERFCReturns the complementary ERF function integrated between x and infinity=ERFC(xx [required]: The lower bound for integrating ERFC.)=ERFC(x)
  • x (required): The lower bound for integrating ERFC.
22ERFC.PRECISEReturns the complementary ERF function integrated between x and infinity=ERFC.PRECISE(xx [required]: The lower bound for integrating ERFC.)=ERFC.PRECISE(x)
  • x (required): The lower bound for integrating ERFC.
23GESTEPReturns 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])
  • number (required): The value to test against step.
  • step (optional): The threshold value.
24HEX2BINConverts 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])
  • number (required): The hexadecimal number you want to convert.
  • places (optional): The number of characters to use.
25HEX2DECConverts a hexadecimal number to decimal=HEX2DEC(numbernumber [required]: The hexadecimal number you want to convert.)=HEX2DEC(number)
  • number (required): The hexadecimal number you want to convert.
26HEX2OCTConverts 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])
  • number (required): The hexadecimal number you want to convert.
  • places (optional): The number of characters to use.
27IMABSReturns 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)
  • inumber (required): A complex number for which you want the absolute value.
28IMAGINARYReturns 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)
  • inumber (required): A complex number for which you want the imaginary coefficient.
29IMARGUMENTReturns 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)
  • inumber (required): A complex number for which you want the argument.
30IMCONJUGATEReturns 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)
  • inumber (required): A complex number for which you want the conjugate.
31IMCOSReturns 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)
  • inumber (required): A complex number for which you want the cosine.
32IMCOSHReturns 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)
  • inumber (required): A complex number for which you want the hyperbolic cosine.
33IMCOTReturns 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)
  • inumber (required): A complex number for which you want the cotangent.
34IMCSCReturns 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)
  • inumber (required): A complex number for which you want the cosecant.
35IMCSCHReturns 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)
  • inumber (required): A complex number for which you want the hyperbolic cosecant.
36IMDIVReturns 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)
  • inumber1 (required): The complex numerator or dividend.
  • inumber2 (required): The complex denominator or divisor.
37IMEXPReturns 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)
  • inumber (required): A complex number for which you want the exponential.
38IMLNReturns 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)
  • inumber (required): A complex number for which you want the natural logarithm.
39IMLOG10Returns 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)
  • inumber (required): A complex number for which you want the common logarithm.
40IMLOG2Returns 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)
  • inumber (required): A complex number for which you want the base-2 logarithm.
41IMPOWERReturns 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)
  • inumber (required): A complex number you want to raise to a power.
  • number (required): The power to which you want to raise the complex number.
42IMPRODUCTReturns 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], ...)
  • inumber2 (required): A complex number to use improduct function on
  • inumber1 (optional): Additional complex numbers
43IMREALReturns 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)
  • inumber (required): A complex number for which you want the real coefficient.
44IMSECReturns 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)
  • inumber (required): A complex number for which you want the secant.
45IMSECHReturns 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)
  • inumber (required): A complex number for which you want the hyperbolic secant.
46IMSINReturns 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)
  • inumber (required): A complex number for which you want the sine.
47IMSINHFunction 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)
  • inumber (required): A complex number for which you want the hyperbolic sine.
48IMSQRTReturns 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)
  • inumber (required): A complex number for which you want the square root.
49IMSUBReturns 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)
  • inumber1 (required): The complex number from which to subtract inumber2.
  • inumber2 (required): The complex number to subtract from inumber1.
50IMSUMReturns 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], ...)
  • inumber1 (required): The complex number you want to add.
  • inumber2 (optional): Additional optional complex numbers.
51IMTANReturns 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)
  • inumber (required): A complex number for which you want the tangent.
52OCT2BINConverts 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])
  • number (required): The octal number you want to convert.
  • places (optional): The number of characters to use.
53OCT2DECConverts an octal number to decimal=OCT2DEC(numbernumber [required]: The octal number you want to convert.)=OCT2DEC(number)
  • number (required): The octal number you want to convert.
54OCT2HEXConverts 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])
  • number (required): The octal number you want to convert.
  • places (optional): The number of characters to use.

Created by admin on 2/9/2021

 

0 Comments for '(Excel) - List of Excel Engineering Functions with Syntax and Arguments'   

 
Email me replies   

Please kindly review and accept Terms of Use and Cookie & Policy Policy