windowsforms-15494-controls-and-libraries-spreadsheet-formulas-functions-engineering-functions.md
This document describes engineering functions supported by the WinForms Spreadsheet control.
|
Name
|
Description
|
Syntax
| | --- | --- | --- | |
|
Returns the modified Bessel function In(x).
|
BESSELI(X, N)
| |
|
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.
| |
|
Returns the modified Bessel function Kn(x).
|
BESSELK(X, N)
| |
|
Returns the Bessel function Yn(x).
|
BESSELY(X, N)
| |
|
Converts a binary number to decimal.
|
BIN2DEC(number)
| |
|
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.
| |
|
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.
| |
|
Returns a bitwise ‘AND’ of two numbers.
|
BITAND( number1, number2)
| |
|
Returns a number shifted left by the specified number of bits.
|
BITLSHIFT(number, shift_amount)
| |
|
Returns a bitwise ‘OR’ of two numbers.
|
BITOR(number1, number2)
| |
|
Returns a number shifted right by the specified number of bits.
|
BITRSHIFT(number, shift_amount)
| |
|
Returns a bitwise ‘XOR’ of two numbers.
|
BITXOR(number1, number2)
| |
|
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”.
| |
|
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.
| |
|
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.
| |
|
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.
| |
|
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.
| |
|
Tests whether two values are equal.
|
DELTA(number1, number2)
| |
|
Returns the error function integrated between lower_limit and upper_limit.
|
ERF(lower_limit,[upper_limit])
| |
|
Returns the complementary ERF function integrated between x and infinity.
|
ERFC(x)
| |
|
Returns the complementary ERF function integrated between x and infinity.
|
ERFC.PRECISE(x)
| |
|
Returns the error function.
|
ERF.PRECISE(x)
| |
|
Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values.
|
GESTEP(number,step)
| |
|
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.
| |
|
Converts a hexadecimal number to decimal.
|
HEX2DEC(number)
| |
|
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.
| |
|
Returns the absolute value (the modulus) of a complex number.
|
IMABS(inumber)
| |
|
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
|
IMAGINARY(inumber)
| |
|
Returns the argument theta (an angle expressed in radians) of a complex number.
|
IMARGUMENT(inumber)
| |
|
Returns the complex conjugate of a complex number in x + yi or x + yj text format.
|
IMCONJUGATE(inumber)
| |
|
Returns the cosine of a complex number
|
IMCOS(inumber)
| |
|
Returns the hyperbolic cosine of a complex number.
|
IMCOSH(inumber)
| |
|
Returns the cotangent of a complex number.
|
IMCOT(inumber)
| |
|
Returns the cosecant of a complex number.
|
IMCSC(inumber)
| |
|
Returns the hyperbolic cosecant of a complex number.
|
IMCSCH(inumber)
| |
|
Returns the quotient of two complex numbers in x + yi or x + yj text format.
|
IMDIV(inumber1,inumber2)
| |
|
Returns the exponential of a complex number in x + yi or x + yj text format.
|
IMEXP(inumber)
| |
|
Returns the natural logarithm of a complex number in x + yi or x + yj text format.
|
IMLN(inumber)
| |
|
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
|
IMLOG10(inumber)
| |
|
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.
|
IMLOG2(inumber)
| |
|
Returns a complex number raised raised to a power.
|
IMPOWER(inumber, number)
| |
|
Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format.
|
IMPRODUCT(inumber1,inumber2,…)
| |
|
Returns the real coefficient of a complex number in x + yi or x + yj text format.
|
IMREAL(inumber)
| |
|
Returns the secant of a complex number.
|
IMSEC(inumber)
| |
|
Returns the hyperbolic secant of a complex number.
|
IMSECH(inumber)
| |
|
Returns the sine of a complex number in x + yi or x + yj text format.
|
IMSIN(inumber)
| |
|
Returns the hyperbolic sine of a complex number.
|
IMSINH(inumber)
| |
|
Returns the square root of a complex number in x + yi or x + yj text format.
|
IMSQRT(inumber)
| |
|
Returns the difference of two complex numbers in x + yi or x + yj text format.
|
IMSUB(inumber1,inumber2)
| |
|
Returns the sum of two or more complex numbers.
|
IMSUM(inumber1, inumber2, …)
| |
|
Returns the tangent of a complex number.
|
IMTAN(number)
| |
|
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.
| |
|
Converts an octal number to decimal.
|
OCT2DEC(number)
| |
|
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.
|
See Also