Engineering Functions
| Formulas | Description | Examples |
|---|---|---|
| BESSELI | Syntax: BESSELI(X, N) Returns the modified Bessel function In(x), which is equivalent to the Bessel function evaluated for purely imaginary arguments. |
=BESSELI(1.5, 1) |
| BESSELJ | Syntax: BESSELJ(X, N) Returns the Bessel function Jn(x). |
=BESSELJ(1.9, 2) |
| BESSELK | Syntax: BESSELK(X, N) Returns the modified Bessel function Kn(x) |
=BESSELK(1.5, 1) |
| BESSELY | Syntax: BESSELY(X, N) Returns the Bessel function Yn(x). |
=BESSELY(2.5, 1) |
| BIN2DEC | Syntax: BIN2DEC(number) Converts a binary number to decimal. |
=BIN2DEC(101010) |
| BIN2HEX | Syntax: BIN2HEX(number, [places]) Converts a binary number to hexadecimal. |
=BIN2HEX(101010, 5) |
| BIN2OCT | Syntax: BIN2OCT(number, [places]) Converts a binary number to octal. |
=BIN2OCT(101010) |
| BITAND | Syntax: BITAND(number1, number2) Returns a bitwise 'AND' of two numbers. |
=BITAND(1, 2) |
| BITOR | Syntax: BITOR(number1, number2) Returns a bitwise 'OR' of two numbers. |
=BITOR(1, 2) |
| BITXOR | Syntax: BITXOR(number1, number2) Returns a bitwise 'XOR' of two numbers. |
=BITXOR(1, 2) |
| BITLSHIFT | Syntax: BITLSHIFT(number, shift_number) Returns a number shifted left by the specified number of bits. |
=BITLSHIFT(1, 2) |
| BITRSHIFT | Syntax: BITRSHIFT(number, shift_number) Returns a number shifted right by the specified number of bits. |
=BITRSHIFT(1, 2) |
| CONVERT | Syntax: CONVERT(number, from_unit, to_unit) This function is used to convert a number from one measurement system to another. |
=CONVERT(10, "sg", "g") |
| DEC2BIN | Syntax: DEC2BIN(number, [places]) Converts a decimal number to binary. |
=DEC2BIN(9, 4) |
| DEC2HEX | Syntax: DEC2HEX(number, [places]) Converts a decimal number to hexadecimal. |
=DEC2HEX(100, 4) |
| DEC2OCT | Syntax: DEC2OCT(number, [places]) Converts a decimal number to octal. |
=DEC2OCT(58, 3) |
| DELTA | Syntax: DELTA(number1, [number2]) Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. If omitted, number2 is assumed to be zero. |
=DELTA(2, 1) |
| ERF | Syntax: ERF(lower_limit,[upper_limit]) Returns the error function integrated between lower_limit and upper_limit. If upper_limit omitted, ERF integrates between zero and lower_limit. |
=ERF(1, 2) |
| ERFC | Syntax: ERFC(lower_limit,[upper_limit]) Returns the complementary error function integrated between lower_limit and upper_limit. If upper_limit omitted, ERF integrates between lower_limit and infinity. |
=ERFC(1, 2) |
| GESTEP | Syntax: GESTEP(number,[step]) Returns 1 if number >= step; returns 0 (zero) otherwise. Use this function to filter a set of values. |
=GESTEP(1, 2) |
| HEX2BIN | Syntax: HEX2BIN(number, [places]) Converts a hexadecimal number to binary. |
=HEX2BIN("F", 8) |
| HEX2DEC | Syntax: HEX2DEC(number) Converts a hexadecimal number to decimal. |
=HEX2DEC("A5") |
| HEX2OCT | Syntax: HEX2OCT(number, [places]) Converts a hexadecimal number to oct. |
=HEX2OCT("F", 3) |
| IMABS | Syntax: IMABS(inumber) Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the absolute value. |
=IMABS("3+4i") |
| IMAGINARY | Syntax: IMAGINARY(inumber) Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the imaginary coefficient. |
=IMAGINARY("3+4i") |
| IMARGUMENT | Syntax: IMARGUMENT(inumber) Returns the argument Theta (theta), an angle expressed in radians. Inumber is a complex number for which you want the argument Theta. |
=IMARGUMENT("3+4i") |
| IMCOS | Syntax: IMCOS(inumber) Returns the cosine of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the cosine. |
=IMCOS("3+4i") |
| IMCOSH | Syntax: IMCOSH(inumber) Returns the hyperbolic cosine of a complex number in x+yi or x+yj text format. Inumber is a complex number for which you want the hyperbolic cosine. |
=IMCOSH("3+4i") |
| IMCOT | Syntax: IMCOT(inumber) Returns the cotangent of a complex number in x+yi or x+yj text format. Inumber is a complex number for which you want the cotangent. |
=IMCOT("3+4i") |
| IMCSC | Syntax: IMCSC(inumber) Returns the cosecant of a complex number in x+yi or x+yj text format. Inumber is a complex number for which you want the cosecant. |
=IMCSC("3+4i") |
| IMCSCH | Syntax: IMCSCH(inumber) Returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format. Inumber is a complex number for which you want the hyperbolic cosecant. |
=IMCSCH("3+4i") |
| IMCONJUGATE | Syntax: IMCONJUGATE(inumber) Returns the complex conjugate of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the conjugate. |
=IMCONJUGATE("3+4i") |
| IMDIV | Syntax: IMDIV(inumber1, inumber2) Returns the quotient of two complex numbers in x + yi or x + yj text format. Inumber1 is the complex numerator or dividend. Inumber2 is the complex denominator or divisor. |
=IMDIV("3+4i", "2+2i") |
| IMEXP | Syntax: IMEXP(inumber) Returns the exponential of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the exponential. |
=IMEXP("3+4i") |
| IMLN | Syntax: IMLN(inumber) Returns the natural logarithm of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the natural logarithm. |
=IMLN("3+4i") |
| IMLOG2 | Syntax: IMLOG2(inumber) Returns the base-2 logarithm of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the base-2 logarithm. |
=IMLOG2("3+4i") |
| IMLOG10 | Syntax: IMLOG10(inumber) Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the common logarithm. |
=IMLOG10("3+4i") |
| IMPOWER | Syntax: IMPOWER(inumber, number) Returns a complex number in x + yi or x + yj text format raised to a power. Inumber is a complex number for which you want to raise to a power. Number is the power to which you want to raise the complex number. |
=IMPOWER("3+4i", "2+2i") |
| IMPRODUCT | Syntax: IMPRODUCT(inumber1,inumber2...) Returns the product of 2 to 29 complex numbers in x + yi or x + yj text format. Inumber1,inumber2,... are 1 to 29 complex numbers to multiply. |
=IMPRODUCT("3+4i", "2+2i") |
| IMREAL | Syntax: IMREAL(inumber) Returns the real coefficient of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the real coefficient. |
=IMREAL("3+4i") |
| IMSEC | Syntax: IMSEC(inumber) Returns the secant of a complex number in x+yi or x+yj text format. Inumber is a complex number for which you want the secant. |
=IMSEC("3+4i") |
| IMSECH | Syntax: IMSECH(inumber) Returns the hyperbolic secant of a complex number in x+yi or x+yj text format. Inumber is a complex number for which you hyperbolic secant. |
=IMSECH("3+4i") |
| IMSIN | Syntax: IMSIN(inumber) Returns the sine of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the sine. |
=IMSIN("3+4i") |
| IMSINH | Syntax: IMSINH(inumber) Returns the hyperbolic sine of a complex number in x+yi or x+yj text format. Inumber is a complex number for which you want the hyperbolic sine. |
=IMSINH("3+4i") |
| IMSQRT | Syntax: IMSQRT(inumber1) Returns the square root of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the square root. |
=IMSQRT("3+4i") |
| IMSUM | Syntax: IMSUM(inumber1,inumber2...) Returns the sum of two or more complex numbers in x + yi or x + yj text format. Inumber1,inumber2,... are 1 to 29 complex numbers to add. |
=IMSUM("3+4i", "2+2i") |
| IMSUB | Syntax: IMSUB(inumber1,inumber2) Returns the difference of two complex numbers in x + yi or x + yj text format. Inumber1,inumber2, the complex number from which to subtract. |
=IMSUB("3+4i", "2+2i") |
| IMTAN | Syntax: IMTAN(inumber) Returns the tangent of a complex number in x + yi or x + yj text format. Inumber is a complex number for which you want the tangent. |
=IMTAN("3+4i") |
| OCT2BIN | Syntax: OCT2BIN(number, [places]) Converts an Octal (Base 8) number into a Binary (Base 2) number. |
=OCT2BIN("2", 10) |
| OCT2DEC | Syntax: OCT2DEC(number) Converts an octal number to decimal. |
=OCT2DEC(54) |
| OCT2HEX | Syntax: OCT2HEX(number, [places]) Converts an octal number to hexadecimal. |
=OCT2HEX(100, 4) |