Technische Funktionen

Top  Previous  Next

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 number shifted left by the specified number of bits.

BITLSHIFT(number, shift_amount)

BITOR 




Returns a bitwise ‘OR’ of two numbers.

BITOR(number1, number2)

BITRSHIFT 




Returns a number shifted right by the specified number of bits.

BITRSHIFT(number, shift_amount)

BITXOR 




Returns a bitwise ‘XOR’ 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.

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 theta (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 raised to a power.

IMPOWER(inumber, number)

IMPRODUCT 




Returns the product of 1 to 255 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 square root 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 two or more 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.