Page 447 - Excel for Scientists and Engineers: Numerical Methods

424 EXCEL: NUMERICAL METHODS

FACTDOUBLE3 Returns the double factorial of a number. See On-Line
Help for more information.
GCD3 Returns the greatest common divisor of 1 to 29 integers.

GESTEP Tests whether a number is greater than a threshold value
HEX2BIN Converts a hexadecimal number to binary
HEX2DEC Converts a hexadecimal number to decimal
HEX20CT Converts a hexadecimal number to octal
IMABS Returns the absolute value (modulus) of a complex number
IMAGl NARY Returns the imaginary coefficient of a complex number
IMARGUMENT Returns the argument theta, an angle expressed in radians
IMCONJUGATE Returns the complex conjugate of a complex number

IMCOS Returns the cosine of a complex number in x + yi or x + yj
text format.
IMDIV Returns the quotient of two complex numbers

IMEXP Returns the exponential of a complex number
IMLN Returns the natural logarithm of a complex number
IMLOGIO Returns the base-10 logarithm of a complex number
IMLOG2 Returns the base-2 logarithm of a complex number
IMPOWER Returns a complex number raised to an integer power
IMPRODUCT Returns the product of 1 to 29 complex numbers

IMREAL Returns the real part of a complex number
IMSIN Returns the sine of a complex number
IMSQRT Returns the square root of a complex number
IMSUB Returns the difference of two complex numbers
IMSUM Returns the sum of 1 to 29 complex numbers
ISEVEN* Returns TRUE if number is even, or FALSE if number is
odd
ISODD' Returns TRUE if number is odd, or FALSE if number is
even
LCM3 Returns the least common multiple of 1 to 29 integers.
MROUND3 Returns a number rounded to the desired multiple.
MU LTNOM IAL3 Returns the ratio of the factorial of a sum of values to the
product of factorials.
OCT2 B I N Converts an octal number to binary