Engineering Functions
- 6 minutes to read
This document describes engineering functions supported by the non-visual Spreadsheet component.
Name | Description | Syntax |
---|---|---|
Returns the modified Bessel function In | BESSELI | |
Calculates the Bessel function Jn | BESSELJ 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. | |
Returns the modified Bessel function Kn | BESSELK | |
Returns the Bessel function Yn | BESSELY | |
Converts a binary number to decimal. | BIN2DEC | |
Converts a binary number to hexadecimal. | BIN2HEX 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. | |
Converts a binary number to octal. | BIN2OCT 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. | |
Returns a bitwise ‘AND’ of two numbers. | BITAND( number1, number2) | |
Returns a number shifted left by the specified number of bits. | BITLSHIFT | |
Returns a bitwise ‘OR’ of two numbers. | BITOR | |
Returns a number shifted right by the specified number of bits. | BITRSHIFT | |
Returns a bitwise ‘XOR’ of two numbers. | BITXOR | |
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. | COMPLEX 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”. | |
Converts a number from one measurement system to another. | CONVERT 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. | |
Converts a decimal number to binary. | DEC2BIN 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. | |
Converts a decimal number to hexadecimal. | DEC2HEX 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. | |
Converts a decimal number to octal. | DEC2OCT 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. | |
Tests whether two values are equal. | DELTA | |
Returns the error function integrated between lower_limit and upper_limit. | ERF | |
Returns the complementary ERF function integrated between x and infinity. | ERFC | |
Returns the complementary ERF function integrated between x and infinity. | ERFC. | |
Returns the error function. | ERF. | |
Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. | GESTEP | |
Converts a hexadecimal number to binary. | HEX2BIN 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. | |
Converts a hexadecimal number to decimal. | HEX2DEC | |
Converts a hexadecimal number to octal. | HEX2OCT 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. | |
Returns the absolute value (the modulus) of a complex number. | IMABS | |
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. | IMAGINARY | |
Returns the argument theta (an angle expressed in radians) of a complex number. | IMARGUMENT | |
Returns the complex conjugate of a complex number in x + yi or x + yj text format. | IMCONJUGATE | |
Returns the cosine of a complex number | IMCOS | |
Returns the hyperbolic cosine of a complex number. | IMCOSH | |
Returns the cotangent of a complex number. | IMCOT | |
Returns the cosecant of a complex number. | IMCSC | |
Returns the hyperbolic cosecant of a complex number. | IMCSCH | |
Returns the quotient of two complex numbers in x + yi or x + yj text format. | IMDIV | |
Returns the exponential of a complex number in x + yi or x + yj text format. | IMEXP | |
Returns the natural logarithm of a complex number in x + yi or x + yj text format. | IMLN | |
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. | IMLOG10 | |
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format. | IMLOG2 | |
Returns a complex number raised raised to a power. | IMPOWER | |
Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format. | IMPRODUCT | |
Returns the real coefficient of a complex number in x + yi or x + yj text format. | IMREAL | |
Returns the secant of a complex number. | IMSEC | |
Returns the hyperbolic secant of a complex number. | IMSECH | |
Returns the sine of a complex number in x + yi or x + yj text format. | IMSIN | |
Returns the hyperbolic sine of a complex number. | IMSINH | |
Returns the square root of a complex number in x + yi or x + yj text format. | IMSQRT | |
Returns the difference of two complex numbers in x + yi or x + yj text format. | IMSUB | |
Returns the sum of two or more complex numbers. | IMSUM | |
Returns the tangent of a complex number. | IMTAN | |
Converts an octal number to binary. | OCT2BIN 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. | |
Converts an octal number to decimal. | OCT2DEC | |
Converts an octal number to hexadecimal. | OCT2HEX 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. |