Microsoft Office Tutorials and References

In Depth Information

**DDE and External Functions**

Returns the actual Bessel function. X is the value at which to

evaluate the function. Y is the order of the Bessel function.

BESSELJ

Returns the Bessel function in modified form for imaginar y

arguments.

BESSELK

Returns the Bessel function, also known as the Weber or Neumann

function. X is the value at which to evaluate the function. N is the

order of the function.

BESSELY

Converts a binar y number to decimal form.

BIN2DEC

Converts a binar y number to hexadecimal.

BIN2HEX

Converts a binar y number to octal.

BIN2OCT

Converts real and imaginar y coefficients into a complex number

of the form
x + yi
or
x + yj
.

COMPLEX

Converts from one measurement system to another.

CONVERT

Converts decimal numbers to binar y.

DEC2BIN

Converts decimal numbers to hexadecimal.

DEC2HEX

Converts decimal numbers to octal.

DEC2OCT

Tests whether numbers or values are equal.

DELTA

Returns the integrated error function between lower limit and

upper limit.

ERF

Returns a complementar y ERF function integrated between x and

infinity. X is the lower bound for integrating ERF.

ERFC

Returns the value of 1 if the number is greater than or equal to

the step, other wise 0.

GESTEP

Converts hexadecimal numbers to binar y.

HEX2BIN

Converts hexadecimal numbers to decimal.

HEX2DEC

Converts hexadecimal numbers to octal.

HEX2OCT

Returns the absolute value (Modulus) of a complex number in

x + yi
or
x + yj
text format.

IMABS

Returns the coefficient of a complex number
x + yi
or
x + yj
in

text format.

IMAGINARY

Returns the Theta argument as an angle expressed in radians.

IMARGUMENT

Returns the complex conjugate of a complex number

x + yi
or
x + yj
in text format.

IMCONJUGATE

Returns the cosine of a complex number
x + yi
or
x + yj
in text

format.

IMCOS

Returns the quotient of complex numbers
x + yi
or
x + yj
in

text format.

IMDIV