SpreadJS 14
Formula Reference / Formula Functions / Engineering Functions
In This Topic
    Engineering Functions
    In This Topic

    Spread provides the following engineering functions, listed alphabetically.

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