Page 257 - Excel Data Analysis
P. 257
14 537547 AppB.qxd 3/4/03 11:57 AM Page 243
EXCEL FUNCTION QUICK REFERENCE B
ENGINEERING FUNCTIONS (CONTINUED)
FUNCTION DESCRIPTION
HEX2OCT(number[, places]) AT Converts a hexadecimal number to an octal number. Unless
specified, uses the minimum number of characters.
IMABS(inumber) AT Returns the absolute value of a complex number.
IMAGINARY(inumber) AT Returns the imaginary coefficient of a complex number.
IMARGUMENT(inumber) AT Returns the theta argument for an angle measurement expressed
in radians.
IMCONJUGATE(inumber) AT Returns the complex conjugate of a complex number.
IMCOS(inumber) AT Determines the cosine for a complex number.
IMDIV(inumber1, inumber2) AT Finds the quotient of two complex numbers.
IMEXP(inumber) AT Finds the exponential of a complex number.
IMLN(inumber) AT Determines the natural logarithm of a complex number.
IMLOG10(inumber) AT Finds the base-10 logarithm of a complex number.
IMLOG2(inumber) AT Finds the base-2 logarithm of a complex number.
IMPOWER(inumber, number) AT Returns the result of a complex number raised to the specified
power.
IMPRODUCT(inumber1, inumber2,...) AT Returns the product of 2 or more complex numbers. The
function allows a maximum of 29 complex numbers.
IMREAL(inumber) AT Returns the real coefficient of a complex number.
IMSIN(inumber) AT Determines the sine for a complex number.
IMSQRT(inumber) AT Finds the square root of a complex number.
IMSUB(inumber1, inumber2) AT Subtracts two complex numbers.
IMSUM(inumber1,[inumber2,...]) AT Adds the specified complex numbers.
OCT2BIN(number[, places]) AT Converts an octal number to a binary number. Unless specified,
uses the minimum number of characters.
OCT2DEC(number) AT Converts an octal number to a decimal number.
OCT2HEX(number[, places]) AT Converts an octal number to a hexadecimal number. Unless
specified, uses the minimum number of characters.
243
