• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint

### Engineering Functions Overview

Engineering functions are built-in formulas that allow you to apply engineering analysis against statistical and logical information. The bold font functions in Table 9.1 are covered in this chapter. (To use these functions the Analysis ToolPak must be installed. To install the Analysis ToolPak, select Tools, Add In and then check Analysis ToolPak.)

##### Table 9.1. Engineering Functions
FunctionSyntaxDescription
BESSELI=BESSELI(x,n)Returns the Bessel function of the first kind in modified form for imaginary arguments.
BESSELJ=BESSELJ(x,n)Returns the actual Bessel function of the first kind. X is the value at which to evaluate the function. N is the order of the Bessel function.
BESSELK=BESSELK(x,n)Returns the Bessel function of the second kind in modified form for imaginary arguments.
BESSELY=BESSELY(x,n)Returns the Bessel function of the second kind, also known as the Weber or Neumann function. X is the value at which to evaluate the function. N is the order of the function.
BIN2DEC=BIN2DEC(number)Converts a binary number to decimal form.
BIN2HEX=BIN2HEX(number,places)Converts a binary number to hexadecimal.
BIN2OCT=BIN2OCT(number,places)Converts a binary number to octal.
COMPLEX=COMPLEX(real_num,I_num,suffix)Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj, where i and j are imaginary suffix components.
CONVERT=CONVERT(number,from_unit,to_unit)Converts from one measurement system to another.
DEC2BIN=DEC2BIN(number,places)Converts decimal numbers to binary.
DEC2HEX=DEC2HEX(number,places)Converts decimal numbers to hexadecimal.
DEC2OCT=DEC2OCT(number,places)Converts decimal numbers to octal.
DELTA=DELTA(number1,number2)Tests whether numbers or values are equal.
ERF=ERF(lower_limit,upper_limit)Returns the integrated error function between lower limit and upper limit.
ERFC=ERFC(x)Returns a complementary ERF function integrated between x and infinity. X is the lower bound for integrating ERF.
GESTEP=GESTEP(number,step)Returns the value of 1 if the number is greater than or equal to the step, or threshold, otherwise 0.
HEX2BIN=HEX2BIN(number,places)Converts hexadecimal numbers to binary.
HEX2DEC=HEX2DEC(number)Converts hexadecimal numbers to decimal.
HEX2OCT=HEX2OCT(number,places)Converts hexadecimal numbers to octal.
IMABS=IMABS(inumber)Returns the absolute value (Modulus) of a complex number in x+yi or x+yj text format.
IMAGINARY=IMAGINARY(inumber)Returns the coefficient of a complex number in x+yi or x+yj text format.
IMARGUMENT=IMARGUMENT(inumber)Returns the Theta argument as an angle expressed in radians.
IMCONJUGATE=IMCONJUGATE(inumber)Returns the complex conjugate of a complex number in x+yi or x+yj text format.
IMCOS=IMCOS(inumber)Returns the cosine of a complex number in x+yi or x+yj text format.
IMDIV=IMDIV(inumber1,inumber2)Returns the quotient of complex numbers in x+yi or x+yj text format.
IMEXP=IMEXP(inumber)Returns the exponential of complex numbers in x+yi or x+yj text format.
IMLN=IMLN(inumber)Returns the natural logarithm of a complex number in x+yi or x+yj text format.
IMLOG10=IMLOG10(inumber)Returns the common logarithm (base 10) of a complex number in x+yi or x+yj text format.
IMLOG2=IMLOG2(inumber)Returns the base 2 logarithm of a complex number in x+yi or x+yj text format.
IMPOWER=IMPOWER(inumber,number)Returns a complex number in x+yi or x+yj text format raised to a power.
IMPRODUCT=IMPRODUCT(inumber1,inumber2,...)Returns the product from 2 to 29 complex numbers in x+yi or x+yj text format.
IMREAL=IMREAL(inumber)Returns real coefficient of complex numbers in x+yi or x+yj text format.
IMSIN=IMSIN(inumber)Returns the sine of a complex number in x+yi or x+yj text format.
IMSQRT=IMSQRT(inumber)Returns the square root of a complex number in x+yi or x+yj text format.
IMSUB=IMSUB(inumber1,inumber2)Returns the difference of two complex numbers in x+yi or x+yj text format.
IMSUM=IMSUM(inumber1,inumber2,...)Returns the sum of two complex numbers in x+yi or x+yj text format.
OCT2BIN=OCT2BIN(number,places)Converts an octal number to binary.
OCT2DEC=OCT2DEC(number)Converts an octal number to decimal.
OCT2HEX=OCT2HEX(number,places)Converts an octal number to hexadecimal.

PREVIEW

Not a subscriber?

Start A Free Trial

• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint