Engineering Functions
- 6 minutes to read
This document briefly describes engineering functions implemented in the Spreadsheet.
Name | Description | Syntax |
---|---|---|
BESSELI | Returns the modified Bessel function In(x). | BESSELI(X, N) |
BESSELJ | Calculates the Bessel function Jn(x). | BESSELJ(X, N) X is the value at which to evaluate the function. N is the order of the Bessel function. If n is not an integer, it is truncated. |
BESSELK | Returns the modified Bessel function Kn(x). | BESSELK(X, N) |
BESSELY | Returns the Bessel function Yn(x). | BESSELY(X, N) |
BIN2DEC | Converts a binary number to decimal. | BIN2DEC(number) |
BIN2HEX | Converts a binary number to hexadecimal. | BIN2HEX(number, [places]) Number is the binary number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |
BIN2OCT | Converts a binary number to octal. | BIN2OCT(number, [places]) Number is the binary number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |
BITAND | Returns a ‘Bitwise And’ of two numbers. | BITAND( number1, number2) |
BITLSHIFT | Returns a value number shifted left by shift_amount bits. | BITLSHIFT(number, shift_amount) |
BITOR | Returns a bitwise OR of 2 numbers. | BITOR(number1, number2) |
BITRSHIFT | Returns a value number shifted right by shift_amount bits. | BITRSHIFT(number, shift_amount) |
BITXOR | Returns a bitwise ‘Exclusive Or’ of two numbers. | BITXOR(number1, number2) |
COMPLEX | Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. | COMPLEX(real_num,i_num,suffix) Real_num is the real coefficient of the complex number. I_num is the imaginary coefficient of the complex number. Suffix is the suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be “i”. |
CONVERT | Converts a number from one measurement system to another. | CONVERT(number, from_unit, to_unit) Number is the number to be converted. From_unit is a text string, denoting the current unit. From_unit is a text string, denoting the unit to which the number will be cconverted. |
DEC2BIN | Converts a decimal number to binary. | DEC2BIN(number, [places]) Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |
DEC2HEX | Converts a decimal number to hexadecimal. | DEC2HEX(number, [places]) Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |
DEC2OCT | Converts a decimal number to octal. | DEC2OCT(number, [places]) Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |
DELTA | Tests whether two values are equal. | DELTA(number1, number2) |
ERF | Returns the error function integrated between lower_limit and upper_limit. | ERF(lower_limit,[upper_limit]) |
ERFC | Returns the complementary ERF function integrated between x and infinity. | ERFC(x) |
ERFC.PRECISE | Returns the complementary ERF function integrated between x and infinity. | ERFC.PRECISE(x) |
ERF.PRECISE | Returns the error function integrated between 0 and a specified limit. | ERF.PRECISE(x) |
GESTEP | Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. | GESTEP(number,step) |
HEX2BIN | Converts a hexadecimal number to binary. | HEX2BIN(number, [places]) Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |
HEX2DEC | Converts a hexadecimal number to decimal | HEX2DEC(number) |
HEX2OCT | Converts a hexadecimal number to octal. | HEX2OCT(number, [places]) Number is the decimal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |
IMABS | Returns the absolute value (the modulus) of a complex number. | IMABS(inumber) |
IMAGINARY | Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. | IMAGINARY(inumber) |
IMARGUMENT | Returns the argument (an angle expressed in radians) of a complex number. | IMARGUMENT(inumber) |
IMCONJUGATE | Returns the complex conjugate of a complex number in x + yi or x + yj text format. | IMCONJUGATE(inumber) |
IMCOS | Returns the cosine of a complex number | IMCOS(inumber) |
IMCOSH | Returns the hyperbolic cosine of a complex number. | IMCOSH(inumber) |
IMCOT | Returns the cotangent of a complex number. | IMCOT(inumber) |
IMCSC | Returns the cosecant of a complex number. | IMCSC(inumber) |
IMCSCH | Returns the hyperbolic cosecant of a complex number. | IMCSCH(inumber) |
IMDIV | Returns the quotient of two complex numbers in x + yi or x + yj text format. | IMDIV(inumber1,inumber2) |
IMEXP | Returns the exponential of a complex number in x + yi or x + yj text format. | IMEXP(inumber) |
IMLN | Returns the natural logarithm of a complex number in x + yi or x + yj text format. | IMLN(inumber) |
IMLOG10 | Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. | IMLOG10(inumber) |
IMLOG2 | Returns the base-2 logarithm of a complex number in x + yi or x + yj text format. | IMLOG2(inumber) |
IMPOWER | Returns a complex number raised in the specified power. | IMPOWER(inumber, number) |
IMPRODUCT | Returns the product of complex numbers in x + yi or x + yj text format. | IMPRODUCT(inumber1,inumber2,…) |
IMREAL | Returns the real coefficient of a complex number in x + yi or x + yj text format. | IMREAL(inumber) |
IMSEC | Returns the secant of a complex number. | IMSEC(inumber) |
IMSECH | Returns the hyperbolic secant of a complex number. | IMSECH(inumber) |
IMSIN | Returns the sine of a complex number in x + yi or x + yj text format. | IMSIN(inumber) |
IMSINH | Returns the hyperbolic sine of a complex number. | IMSINH(inumber) |
IMSQRT | Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. | IMSQRT(inumber) |
IMSUB | Returns the difference of two complex numbers in x + yi or x + yj text format. | IMSUB(inumber1,inumber2) |
IMSUM | Returns the sum of complex numbers. | IMSUM(inumber1, inumber2, …) |
IMTAN | Returns the tangent of a complex number. | IMTAN(number) |
OCT2BIN | Converts an octal number to binary. | OCT2BIN(number, [places]) Number is the octal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |
OCT2DEC | Converts an octal number to decimal. | OCT2DEC(number) |
OCT2HEX | Converts an octal number to hexadecimal. | OCT2HEX(number, [places]) Number is the octal number to be converted. Places is the number of characters to use. If places is omitted, the minimum number of characters is used. |