Page 446 - Excel for Scientists and Engineers: Numerical Methods

Appendix 5

Engineering

and Other Functions

The following functions are available only if you have loaded the Analysis
ToolPak. Most are listed in the Engineering category in the Insert Function
dialog box.

BESSELl Returns the modified Bessel function In(x)
BESSELJ Returns the Bessel function Jn(x)
BESSELK Returns the modified Bessel function Kn(x)

BESSELY Returns the Bessel function Yn(x)
BIN2DEC Converts a binary number to decimal
BIN2HEX Converts a binary number to hexadecimal
BI N20CT Converts a binary number to octal
COMPLEX Converts real and imaginary coefficients into a complex
number
CONVERT Converts a number from one measurement system to
another

DEC2BIN Converts a decimal number to binary
DEC2HEX Converts a decimal number to hexadecimal
DEC20CT Converts a decimal number to octal
DELTA Tests whether two values are equal
EDATE’ Returns the serial number of the date that is a specified
number of months before or after the specified start date.
EOMONTH’ Returns the serial number of the last day of the month that
is a specified number of months before or after the
specified start date
ERF Returns the error hnction
ERFC Returns the complementary error function

423