EnterpriseSheet formulas

Document -> EnterpriseSheet formula -> Engineering Functions

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) |