This reference lists 54 Excel engineering functions, ordered by frequency of use, with high-frequency functions marked ⭐. Each function includes its syntax and an example.

Function Description Example
BESSELI Returns the modified Bessel function In(x) =BESSELI(x,n) — Returns the modified Bessel function In(x), common in engineering and signal processing
BESSELJ Returns the Bessel function Jn(x) =BESSELJ(x,n) — Returns the Bessel function Jn(x), used to solve wave problems
BESSELK Returns the modified Bessel function Kn(x) =BESSELK(x,n) — Returns the modified Bessel function Kn(x)
BESSELY Returns the Bessel function Yn(x) =BESSELY(x,n) — Returns the Bessel function Yn(x), the Bessel function of the second kind
BIN2DEC Converts a binary number to decimal =BIN2DEC("1010") — Converts binary to decimal — "1010" becomes 10
BIN2HEX Converts a binary number to hexadecimal =BIN2HEX("1010") — Converts binary to hexadecimal — "1010" becomes "A"
BIN2OCT Converts a binary number to octal =BIN2OCT("1010") — Converts binary to octal — "1010" becomes "12"
BITAND Returns a 'Bitwise And' of two numbers =BITAND(5,3) — Returns the bitwise AND of two numbers — 5 AND 3 = 1
BITLSHIFT Returns a value number shifted left by shift_amount bits =BITLSHIFT(2,3) — Shifts a number left by the given bits — 2 shifted 3 places = 16
BITOR Returns a bitwise OR of 2 numbers =BITOR(5,3) — Returns the bitwise OR of two numbers — 5 OR 3 = 7
BITRSHIFT Returns a value number shifted right by shift_amount bits =BITRSHIFT(16,3) — Shifts a number right by the given bits — 16 shifted 3 places = 2
BITXOR Returns a bitwise 'Exclusive Or' of two numbers =BITXOR(5,3) — Returns the bitwise XOR of two numbers — 5 XOR 3 = 6
COMPLEX Converts real and imaginary coefficients into a complex number =COMPLEX(3,4) — Combines real part 3 and imaginary part 4 into the complex number "3+4i"
CONVERT Converts a number from one measurement system to another =CONVERT(100,"cm","in") — Converts 100 centimeters to inches, about 39.37 inches
DEC2BIN Converts a decimal number to binary =DEC2BIN(10) — Converts decimal to binary — 10 becomes "1010"
DEC2HEX Converts a decimal number to hexadecimal =DEC2HEX(255) — Converts decimal to hexadecimal — 255 becomes "FF"
DEC2OCT Converts a decimal number to octal =DEC2OCT(10) — Converts decimal to octal — 10 becomes "12"
DELTA Tests whether two values are equal =DELTA(5,5) — Tests whether two values are equal — 1 if equal, 0 if not
ERF Returns the error function =ERF(0.5) — Returns the error function at 0.5, used in probability calculations
ERF.PRECISE Returns the error function =ERF.PRECISE(0.5) — Returns the precise error function value
ERFC Returns the complementary error function =ERFC(0.5) — Returns the complementary error function, used in statistics
ERFC.PRECISE Returns the complementary error function =ERFC.PRECISE(0.5) — Returns the precise complementary error function value
GESTEP Tests whether a number is greater than a threshold value =GESTEP(5,4) — Tests whether 5 is greater than the threshold 4 — 1 if yes, 0 if no
HEX2BIN Converts a hexadecimal number to binary =HEX2BIN("FF") — Converts hexadecimal to binary — "FF" becomes "11111111"
HEX2DEC Converts a hexadecimal number to decimal =HEX2DEC("FF") — Converts hexadecimal to decimal — "FF" becomes 255
HEX2OCT Converts a hexadecimal number to octal =HEX2OCT("FF") — Converts hexadecimal to octal — "FF" becomes "377"
IMABS Returns the absolute value (modulus) of a complex number =IMABS("3+4i") — Returns the modulus (absolute value) of "3+4i", giving 5
IMAGINARY Returns the imaginary coefficient of a complex number =IMAGINARY("3+4i") — Returns the imaginary part of "3+4i", giving 4
IMARGUMENT Returns the argument theta, an angle expressed in radians =IMARGUMENT("3+4i") — Returns the argument (angle in radians) of "3+4i"
IMCONJUGATE Returns the complex conjugate of a complex number =IMCONJUGATE("3+4i") — Returns the conjugate of "3+4i", giving "3-4i"
IMCOS Returns the cosine of a complex number =IMCOS("1+i") — Returns the cosine of the complex number "1+i"
IMCOSH Returns the hyperbolic cosine of a complex number =IMCOSH("1+i") — Returns the hyperbolic cosine of "1+i"
IMCOT Returns the cotangent of a complex number =IMCOT("1+i") — Returns the cotangent of "1+i"
IMCSC Returns the cosecant of a complex number =IMCSC("1+i") — Returns the cosecant of "1+i"
IMCSCH Returns the hyperbolic cosecant of a complex number =IMCSCH("1+i") — Returns the hyperbolic cosecant of "1+i"
IMDIV Returns the quotient of two complex numbers =IMDIV("1+i","1-i") — Returns the quotient of "(1+i)/(1-i)"
IMEXP Returns the exponential of a complex number =IMEXP("1+i") — Returns the exponential e^(1+i) of "1+i"
IMLN Returns the natural logarithm of a complex number =IMLN("1+i") — Returns the natural logarithm of "1+i"
IMLOG10 Returns the base-10 logarithm of a complex number =IMLOG10("1+i") — Returns the base-10 logarithm of "1+i"
IMLOG2 Returns the base-2 logarithm of a complex number =IMLOG2("1+i") — Returns the base-2 logarithm of "1+i"
IMPOWER Returns a complex number raised to an integer power =IMPOWER("1+i",2) — Returns "1+i" raised to the power of 2
IMPRODUCT Returns the product of from 1 to 255 complex numbers =IMPRODUCT("1+i","2-i") — Returns the product of "1+i" and "2-i"
IMREAL Returns the real coefficient of a complex number =IMREAL("3+4i") — Returns the real part of "3+4i", giving 3
IMSEC Returns the secant of a complex number =IMSEC("1+i") — Returns the secant of "1+i"
IMSECH Returns the hyperbolic secant of a complex number =IMSECH("1+i") — Returns the hyperbolic secant of "1+i"
IMSIN Returns the sine of a complex number =IMSIN("1+i") — Returns the sine of "1+i"
IMSINH Returns the hyperbolic sine of a complex number =IMSINH("1+i") — Returns the hyperbolic sine of "1+i"
IMSQRT Returns the square root of a complex number =IMSQRT("1+i") — Returns the square root of "1+i"
IMSUB Returns the difference between two complex numbers =IMSUB("3+4i","1+i") — Returns "(3+4i)-(1+i) = 2+3i"
IMSUM Returns the sum of complex numbers =IMSUM("1+i","2+3i") — Returns "(1+i)+(2+3i) = 3+4i"
IMTAN Returns the tangent of a complex number =IMTAN("1+i") — Returns the tangent of "1+i"
OCT2BIN Converts an octal number to binary =OCT2BIN("17") — Converts octal to binary — "17" becomes "1111"
OCT2DEC Converts an octal number to decimal =OCT2DEC("17") — Converts octal to decimal — "17" becomes 15
OCT2HEX Converts an octal number to hexadecimal =OCT2HEX("377") — Converts octal to hexadecimal — "377" becomes "FF"

From Online Toolbox (www.vba.net)