Practice free

Engineering functions

Engineering functions convert units and number bases, work with complex numbers and do bitwise math. Most people need only a few, like CONVERT.

54 functions in this category.

Start here

All engineering functions

FunctionWhat it doesLevelSinceSpills?
BESSELI Evaluates the modified Bessel function of the first kind. It shows up in physics and signal-processing models, rarely in business work. Expert 2007 or earlier No
BESSELJ Evaluates the ordinary Bessel function of the first kind, used for wave and vibration problems. Expert 2007 or earlier No
BESSELK Evaluates the modified Bessel function of the second kind, found in heat-flow and field problems. Expert 2007 or earlier No
BESSELY Evaluates the Bessel function of the second kind, used alongside BESSELJ in wave problems. Expert 2007 or earlier No
BIN2DEC Converts a binary number to decimal. Seen in IT, networking and low-level data work. Intermediate 2007 or earlier No
BIN2HEX Converts a binary number to hexadecimal. Seen in IT, networking and low-level data work. Expert 2007 or earlier No
BIN2OCT Converts a binary number to octal. Seen in IT, networking and low-level data work. Expert 2007 or earlier No
BITAND Compares two numbers bit by bit and keeps only bits that are on in both. Used to test flags packed into one number. Expert 2013 No
BITLSHIFT Shifts the bits of a number left, which multiplies by powers of two. Expert 2013 No
BITOR Compares two numbers bit by bit and keeps bits that are on in either. Expert 2013 No
BITRSHIFT Shifts the bits of a number right, which divides by powers of two and drops remainders. Expert 2013 No
BITXOR Compares two numbers bit by bit and keeps bits that differ between them. Expert 2013 No
COMPLEX Builds a complex number from its two parts. Used in electrical and signal engineering. Expert 2007 or earlier No
CONVERT Converts between units of length, weight, time, temperature, volume and more. A quick way to avoid hard-coded conversion factors. Intermediate 2007 or earlier No
DEC2BIN Converts a decimal number to binary. Seen in IT, networking and low-level data work. Intermediate 2007 or earlier No
DEC2HEX Converts a decimal number to hexadecimal. Seen in IT, networking and low-level data work. Intermediate 2007 or earlier No
DEC2OCT Converts a decimal number to octal. Seen in IT, networking and low-level data work. Expert 2007 or earlier No
DELTA Tests whether two numbers are equal and returns 1 or 0, which can be summed to count matches. Expert 2007 or earlier No
ERF Computes the Gaussian error function, used in probability and diffusion calculations. Most users want NORM.S.DIST instead. Expert 2007 or earlier No
ERF.PRECISE A single-argument error function with improved accuracy over older versions of ERF. Expert 2010 No
ERFC Gives the complement of the error function, accurate for large x where 1-ERF loses precision. Expert 2007 or earlier No
ERFC.PRECISE Same result as ERFC, introduced as the modern named version. Expert 2010 No
GESTEP A step function that returns 1 when a value reaches a threshold. Can count values over a limit via SUMPRODUCT. Expert 2007 or earlier No
HEX2BIN Converts a hexadecimal number to binary. Seen in IT, networking and low-level data work. Expert 2007 or earlier No
HEX2DEC Converts a hexadecimal number to decimal. Seen in IT, networking and low-level data work. Intermediate 2007 or earlier No
HEX2OCT Converts a hexadecimal number to octal. Seen in IT, networking and low-level data work. Expert 2007 or earlier No
IMABS Gives the distance of a complex number from zero. Used to get the magnitude of a signal. Expert 2007 or earlier No
IMAGINARY Returns the imaginary part of a complex number. Expert 2007 or earlier No
IMARGUMENT Returns the angle (theta) of the complex number in radians. Expert 2007 or earlier No
IMCONJUGATE Flips the sign of the imaginary part. Expert 2007 or earlier No
IMCOS Returns the cosine of a complex number. Expert 2007 or earlier No
IMCOSH Returns the hyperbolic cosine of a complex number. Expert 2013 No
IMCOT Returns the cotangent of a complex number. Expert 2013 No
IMCSC Returns the cosecant of a complex number. Expert 2013 No
IMCSCH Returns the hyperbolic cosecant of a complex number. Expert 2013 No
IMDIV Divides one complex number by another. Expert 2007 or earlier No
IMEXP Returns e raised to a complex power. Expert 2007 or earlier No
IMLN Returns the natural logarithm of a complex number. Expert 2007 or earlier No
IMLOG10 Returns the base-10 logarithm of a complex number. Expert 2007 or earlier No
IMLOG2 Returns the base-2 logarithm of a complex number. Expert 2007 or earlier No
IMPOWER Raises a complex number to a power. Expert 2007 or earlier No
IMPRODUCT Multiplies complex numbers together. Expert 2007 or earlier No
IMREAL Returns the real part of a complex number. Expert 2007 or earlier No
IMSEC Returns the secant of a complex number. Expert 2013 No
IMSECH Returns the hyperbolic secant of a complex number. Expert 2013 No
IMSIN Returns the sine of a complex number. Expert 2007 or earlier No
IMSINH Returns the hyperbolic sine of a complex number. Expert 2013 No
IMSQRT Returns the square root of a complex number. Expert 2007 or earlier No
IMSUB Subtracts one complex number from another. Expert 2007 or earlier No
IMSUM Adds complex numbers together. Expert 2007 or earlier No
IMTAN Returns the tangent of a complex number. Expert 2013 No
OCT2BIN Converts a octal number to binary. Seen in IT, networking and low-level data work. Expert 2007 or earlier No
OCT2DEC Converts a octal number to decimal. Seen in IT, networking and low-level data work. Expert 2007 or earlier No
OCT2HEX Converts a octal number to hexadecimal. Seen in IT, networking and low-level data work. Expert 2007 or earlier No

Other categories