# Engineering Functions

## Content

Spread provides the following engineering functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [BESSELI](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BESSELI) | This function calculates the modified Bessel function of the first kind evaluated for purely imaginary arguments. |
| [BESSELJ](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BESSELJ) | This function calculates the Bessel function of the first kind. |
| [BESSELK](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BESSELK) | This function calculates the modified Bessel function of the second kind evaluated for purely imaginary arguments. |
| [BESSELY](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BESSELY) | This function calculates the Bessel function of the second kind. |
| [BIN2DEC](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BIN2DEC) | This function converts a binary number to a decimal number. |
| [BIN2HEX](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BIN2HEX) | This function converts a binary number to a hexadecimal number. |
| [BIN2OCT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BIN2OCT) | This function converts a binary number to an octal number. |
| [BITAND](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BITAND) | This function returns a bitwise "AND" of two numbers. |
| [BITLSHIFT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BITLSHIFT) | This function returns a bitwise "OR" of two numbers. |
| [BITOR](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BITOR) | This function returns a bitwise "OR" of two numbers. |
| [BITRSHIFT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BITRSHIFT) | This function returns a bitwise "OR" of two numbers. |
| [BITXOR](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/BITXOR) | This function returns a bitwise "XOR" of two numbers. |
| [COMPLEX](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/COMPLEX) | This function converts real and imaginary coefficients into complex numbers. |
| [CONVERT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/CONVERT) | This function converts a number from one measurement system to its equivalent in another measurement system. |
| [DEC2BIN](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/DEC2BIN) | This function converts a decimal number to a binary number. |
| [DEC2HEX](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/DEC2HEX) | This function converts a decimal number to a hexadecimal number. |
| [DEC2OCT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/DEC2OCT) | This function converts a decimal number to an octal number. |
| [DELTA](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/DELTA) | This function identifies whether two values are equal. Returns 1 if they are equal; returns 0 otherwise. |
| [ERF](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/ERF) | This function calculates the error function integrated between a lower and an upper limit. |
| [ERF.PRECISE](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/ERF.PRECISE) | This function returns the error function. |
| [ERFC](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/ERFC) | This function calculates the complementary error function integrated between a lower limit and infinity. |
| [ERFC.PRECISE](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/ERFC.PRECISE) | This function returns the complementary ERF function. |
| [GESTEP](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/GESTEP) | This function, greater than or equal to step, returns an indication of whether a number is equal to a threshold. |
| [HEX2BIN](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/HEX2BIN) | This function converts a hexadecimal number to a binary number. |
| [HEX2DEC](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/HEX2DEC) | This function converts a hexadecimal number to a decimal number. |
| [HEX2OCT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/HEX2OCT) | This function converts a hexadecimal number to an octal number. |
| [IMABS](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMABS) | This function returns the absolute value or modulus of a complex number. |
| [IMAGINARY](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMAGINARY) | This function returns the imaginary coefficient of a complex number. |
| [IMARGUMENT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMARGUMENT) | This function returns the argument theta, which is an angle expressed in radians. |
| [IMCONJUGATE](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMCONJUGATE) | This function returns the complex conjugate of a complex number. |
| [IMCOS](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMCOS) | This function returns the cosine of a complex number. |
| [IMCOSH](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMCOSH) | This function returns the hyperbolic cosine of a complex number in x+yi or x+yj text format. |
| [IMCOT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMCOT) | This function returns the cotangent of a complex number in x+yi or x+yj text format. |
| [IMCSC](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMCSC) | This function returns the cosecant of a complex number in x+yi or x+yj text format. |
| [IMCSCH](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMCSCH) | This function returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format. |
| [IMDIV](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMDIV) | This function returns the quotient of two complex numbers. |
| [IMEXP](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMEXP) | This function returns the exponential of a complex number. |
| [IMLN](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMLN) | This function returns the natural logarithm of a complex number. |
| [IMLOG10](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMLOG10) | This function returns the common logarithm of a complex number. |
| [IMLOG2](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMLOG2) | This function returns the base-2 logarithm of a complex number. |
| [IMPOWER](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMPOWER) | This function returns a complex number raised to a power. |
| [IMPRODUCT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMPRODUCT) | This function returns the product of up to 29 complex numbers in the x+yi or x+yj text format. |
| [IMREAL](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMREAL) | This function returns the real coefficient of a complex number in the x+yi or x+yj text format. |
| [IMSEC](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMSEC) | This function returns the secant of a complex number in x+yi of x+yj text format. |
| [IMSECH](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMSECH) | This function returns the hyperbolic secant of a complex number in x+yi or x+yj text format. |
| [IMSIN](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMSIN) | This function returns the sine of a complex number in the x+yi or x+yj text format. |
| [IMSINH](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMSINH) | This function returns the hyperbolic sine of a complex number in x+yi of x+yj text format. |
| [IMSQRT](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMSQRT) | This function returns the square root of a complex number in the x+yi or x+yj text format. |
| [IMSUB](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMSUB) | This function returns the difference between two complex numbers in the x+yi or x+yj text format. |
| [IMSUM](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMSUM) | This function returns the sum of two or more complex numbers in the x+yi or x+yj text format. |
| [IMTAN](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/IMTAN) | This function returns the tangent of a complex number in x+yi or x+yj text format. |
| [OCT2BIN](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/OCT2BIN) | This function converts an octal number to a binary number. |
| [OCT2DEC](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/OCT2DEC) | This function converts an octal number to a decimal number. |
| [OCT2HEX](/spreadjs/docs/v17/formulareference/FormulaFunctions/engineering-functions/OCT2HEX) | This function converts an octal number to a hexadecimal number. |