SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
    - BESSELI
    - BESSELJ
    - BESSELK
    - BESSELY
    - BIN2DEC
    - BIN2HEX
    - BIN2OCT
    - BITAND
    - BITLSHIFT
    - BITOR
    - BITRSHIFT
    - BITXOR
    - COMPLEX
    - CONVERT
    - DEC2BIN
    - DEC2HEX
    - DEC2OCT
    - DELTA
    - ERF
    - ERF.PRECISE
    - ERFC
    - ERFC.PRECISE
    - GESTEP
    - HEX2BIN
    - HEX2DEC
    - HEX2OCT
    - IMABS
    - IMAGINARY
    - IMARGUMENT
    - IMCONJUGATE
    - IMCOS
    - IMCOSH
    - IMCOT
    - IMCSC
    - IMCSCH
    - IMDIV
    - IMEXP
    - IMLN
    - IMLOG10
    - IMLOG2
    - IMPOWER
    - IMPRODUCT
    - IMREAL
    - IMSEC
    - IMSECH
    - IMSIN
    - IMSINH
    - IMSQRT
    - IMSUB
    - IMSUM
    - IMTAN
    - OCT2BIN
    - OCT2DEC
    - OCT2HEX
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - RegEx Functions
  - Other Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

Engineering Functions

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 complex numbers.
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 between 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.