(Showing Draft Content)

# 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.