Page 256 - Excel Data Analysis
P. 256
14 537547 AppB.qxd 3/4/03 11:57 AM Page 242
APPENDIX
EXCEL FUNCTION QUICK REFERENCE
(CONTINUED)
ENGINEERING FUNCTIONS
FUNCTION DESCRIPTION
BESSELI(x, n) AT Returns the modified Bessel function In(x).
BESSELJ(x, n) AT Returns the Bessel function Jn(x).
BESSELK(x, n) AT Returns the modified Bessel function Kn(x).
BESSELY(x, n) AT Returns the Bessel function Yn(x).
BIN2DEC(number) AT Converts a binary number to a decimal number.
BIN2HEX(number[, places]) AT Converts a binary number to a hexadecimal number. Unless
specified, uses the minimum number of characters.
BIN2OCT(number[, places]) AT Converts a binary number to an octal number. Unless specified,
uses the minimum number of characters.
COMPLEX(real_num, i_num[, suffix]) AT Converts real and imaginary coefficients into complex numbers.
CONVERT(number, from_unit, to_unit) AT Converts a number from one measurement system to another,
such as converting meters to feet.
DEC2BIN(number[, places]) AT Converts a decimal number to a binary number. Unless specified,
uses the minimum number of characters.
DEC2HEX(number[, places]) AT Converts a decimal number to a hexadecimal number. Unless
specified, uses the minimum number of characters.
DEC2OCT(number[, places]) AT Converts a decimal number to an octal number. Unless specified,
uses the minimum number of characters.
DELTA(number1[, number2]) AT Determines if two numbers are equal. If the second number is
omitted, it compares the first number to zero.
ERF(lower_limit[, upper_limit]) AT Returns the error function integrated between the specified
limits.
ERFC(x) AT Returns the complimentary error function integrated between
the specified number and infinity.
FACTDOUBLE(number) AT Finds the double factorial of a number.
GESTEP(number[, step]) AT Checks if a number is larger than the threshold value.
HEX2BIN(number[, places]) AT Converts a hexadecimal number to a binary number. Unless
specified, uses the minimum number of characters.
HEX2DEC(number) AT Converts a hexadecimal number to a decimal number.
242
