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.

BESSEL1

BESSELJ

BESSELK

BESSELY

BIN2DEC

B1N2HEX

BIN20CT

COMPLEX

CONVERT

DEC2BIN

DEC2HEX

DEC20CT

DELTA

EDATE1

EOMONTH1

ERF ERFC

Returns the modified Bessel function Jn(x)

Returns the Bessel function Jn(x)

Returns the modified Bessel function Kn(x)

Returns the Bessel function Yn{x)

Converts a binary number to decimal

Converts a binary number to hexadecimal

Converts a binary number to octal

Converts real and imaginary coefficients into a complex number

Converts a number from one measurement system to another

Converts a decimal number to binary

Converts a decimal number to hexadecimal

Converts a decimal number to octal

Tests whether two values are equal

Returns the serial number of the date that is a specified number of months before or after the specified start date.

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

Returns the error function

Returns the complementary error function

FACTDOUBLE

GCD3

GESTEP

HEX2BIN

HEX2DEC

HEX20CT

IMABS

IMAGINARY

IMARGUMENT

UNCONJUGATE

IMCOS

IMDIV

IM EXP

IMLN

IMLOGIO

IMLOG2

IM POWER

IMPRODUCT

IMREAL

IMSIN

IMSQRT

IMSUB

IMSUM

ISEVEN2

ISODD2

LCM3

MROUND3

MULTNOMIAL3

OCT2BIN

Returns the double factorial of a number. See On-Line Help for more information.

Returns the greatest common divisor of 1 to 29 integers.

Tests whether a number is greater than a threshold value

Converts a hexadecimal number to binary

Converts a hexadecimal number to decimal

Converts a hexadecimal number to octal

Returns the absolute value (modulus) of a complex number

Returns the imaginary coefficient of a complex number

Returns the argument theta, an angle expressed in radians

Returns the complex conjugate of a complex number

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

Returns the quotient of two complex numbers

Returns the exponential of a complex number

Returns the natural logarithm of a complex number

Returns the base-10 logarithm of a complex number

Returns the base-2 logarithm of a complex number

Returns a complex number raised to an integer power

Returns the product of 1 to 29 complex numbers

Returns the real part of a complex number

Returns the sine of a complex number

Returns the square root of a complex number

Returns the difference of two complex numbers

Returns the sum of 1 to 29 complex numbers

Returns TRUE if number is even, or FALSE if number is odd

Returns TRUE if number is odd, or FALSE if number is even

Returns the least common multiple of 1 to 29 integers.

Returns a number rounded to the desired multiple.

Returns the ratio of the factorial of a sum of values to the product of factorials.

Converts an octal number to binary

OCT2DEC OCT2HEX QUOTIENT3 RANDBETWEEN3

SERIESSUM

SQRTPI3

WEEKNUM1

WORKDAY1

Converts an octal number to decimal

Converts an octal number to hexadecimal

Returns the integer portion of a division

Returns a random integer between specified lower and upper limits

Returns the sum of a power series. (See On-Line Help for more information)

Returns the square root of (number * 71)

Returns the week number (1-52) in the year

Returns the serial number of the date that is a specified number of workdays before or after the specified start date

1 Listed in Date & Time category

2 Listed in Information category

3 Listed in Math & Trig category

This Page Intentionally Left Blank

0 0

Post a comment