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)