|
*BESSELI(x; n)
|
Calculates the modified Bessel function In(x). x is the value on which the function will be calculated. n is the order of the Bessel function
|
|
*BESSELJ(x; n)
|
Calculates the Bessel function Jn(x) (cylinder function). x is the value on which the function will be calculated. n is the order of the Bessel function
|
|
*BESSELK(x; n)
|
Calculates the modified Bessel function Kn(x). x is the value on which the function will be calculated. n is the order of the Bessel function
|
|
*BESSELY(x; n)
|
Calculates the modified Bessel function Yn(x), also known as the Weber or Neumann function. x is the value on which the function will be calculated. n is the order of the Bessel function
|
|
*BIN2DEC(number)
|
Returns the decimal number for the binary number entered. Number is the binary number.
|
|
*BIN2HEX(number; places)
|
Returns the hexadecimal number for the binary number entered. Number is the binary number. Places is the number of places to be output.
|
|
*BIN2OCT(number; places)
|
Returns the octal number for the binary number entered. Number is the binary number. Places is the number of places to be output.
|
|
*COMPLEX(real_num; i_num; suffix)
|
Returns a complex number from a real coefficient and an imaginary coefficient. Real_num is the real coefficient of the complex number. I_num is the imaginary coefficient of the complex number. Suffix is list of options, "i†or "jâ€.
|
|
*CONVERT_ADD(number; from_unit; to_unit)
|
Converts a value from one unit of measure to the corresponding value in another unit of measure. Number is the number to be converted. From_unit is the unit from which conversion is taking place. To_unit is the unit to which conversion is taking place.
|
|
*DEC2BIN(number; places)
|
Returns the binary number for the decimal number entered between -512 and 511. Number is the decimal number. Places is the number of places to be output.
|
|
*DEC2HEX(number; places)
|
Returns the hexadecimal number for the decimal number entered. Number is the decimal number. Places is the number of places to be output.
|
|
*DEC2OCT(number; places)
|
Returns the octal number for the decimal number entered. Number is the decimal number. Places is the number of places to be output.
|
|
*DELTA(number_1; number_2)
|
Returns TRUE (1) if both numbers are equal, otherwise returns FALSE (0).
|
|
*ERF(lower_limit; upper_limit)
|
Returns values of the Gaussian error integral. Lower_limit is the lower limit of integral. Upper_limit (optional) is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit.
|
|
*ERFC(lower_limit)
|
Returns complementary values of the Gaussian error integral between x and infinity. Lower limit is the lower limit of integral (x).
|
|
*FACTDOUBLE(number)
|
Returns the factorial of the number with increments of 2. If the number is even, the following factorial is calculated: n*(N-2)*(n-4)*...*4*2. If the number is uneven, the following factorial is calculated: n*(N-2)*(n-4)*...*3*1.
|
|
*GESTEP(number; step)
|
Returns 1 if Number is greater than or equal to Step.
|
|
*HEX2BIN(number; places)
|
Returns the binary number for the hexadecimal number entered. Number is the hexadecimal number. Places is the number of places to be output.
|
|
*HEX2DEC(number)
|
Returns the decimal number for the hexadecimal number entered. Number is the hexadecimal number.
|
|
*HEX2OCT(number; places)
|
Returns the octal number for the hexadecimal number entered. Number is the hexadecimal number. Places is the number of places to be output.
|
|
*IMABS(complex_number)
|
Returns the absolute value (modulus) of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMAGINARY(complex _number)
|
Returns the imaginary coefficient of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMARGUMENT(complex _number)
|
Returns the argument (the phi angle) of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMCONJUGATE(complex _number)
|
Returns the conjugated complex complement to a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMCOS(complex_number)
|
Returns the cosine of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMDIV(numerator; denominator)
|
Returns the division of two complex numbers. Numerator, Denominator are entered in the form "x + yi" or "x + yj"
|
|
*IMEXP(complex_number)
|
Returns the power of e (the Eulerian number) and the complex number. The complex_number is entered in the form "x + yi" or "x + yj"
|
|
*IMLN(complex_number)
|
Returns the natural logarithm of a complex_number. The complex_number is entered in the form "x + yi" or "x + yjâ€
|
|
*IMLOG10(complex _number)
|
Returns the common logarithm of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMLOG2(complex _number)
|
Returns the binary logarithm of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMPOWER(complex _number; number)
|
Returns the integer power of a complex_number. The complex number is entered in the form "x + yi" or "x + yj". Number is the exponent.
|
|
*IMPRODUCT(complex _number; complex_number_1; ...)
|
Returns the product of up to 29 complex_numbers. The complex numbers are entered in the form "x + yi" or "x + yj"
|
|
*IMREAL(complex _number)
|
Returns the real coefficient of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMSIN(complex_number)
|
Returns the sine of a complex_number. The complex number is entered in the form "x + yi" or "x + yj"
|
|
*IMSQRT(complex_number)
|
Returns the square root of a complex_number. The complex numbers are entered in the form "x + yi" or "x + yj"
|
|
*IMSUB(complex_number_1; complex_number_2)
|
Returns the subtraction of two complex_numbers. The complex_numbers are entered in the form "x + yi" or "x + yj"
|
|
*IMSUM(complex_number; complex_number_1; ...)
|
Returns the sum of up to 29 complex numbers. The complex_numbers are entered in the form "x + yi" or "x + yj"
|
|
*OCT2BIN(number; places)
|
Returns the binary number for the octal number entered. Number is the octal number. Places is the number of places to be output.
|
|
*OCT2DEC(number)
|
Returns the decimal number for the octal number entered. Number is the octal number.
|
|
*OCT2HEX(number; places)
|
Returns the hexadecimal number for the octal number entered. Number is the octal number. Places is the number of places to be output.
|
