• 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
Function Syntax Description
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 =ERF(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) 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(numbers) Returns the cosine of a complex number in x + yi or x + yj text format.
IMDIV =IMDIV(number1,number2) Returns the quotient of complex numbers in x + yi or x + yj text format.
IMEXP =IMEXP(inumber) Returns the exponential of complex in numbers x + yi or x + yj text format.
IMLN =IMLN(inumber) Returns the natural logarithm of complex numbers in x + yi or x + yj text format.
IMLOG10 =IMLOG10(inumber) Returns the common logarithm (base 10) of complex numbers in x + yi or x + yj text format.
IMLOG2 =IMLOG2(inumber) Returns the base 2 logarithm of complex numbers in x + yi or x + yj text format.
IMPOWER =IMPOWER(inumber,number) Returns a complex number raised to a power in x + yi or x + yj text format.
IMPRODUCT =IMPRODUCT(inumber1, inumber2,…) Returns the product from 2 to 9 complex 2 numbers in x + yi or x + yj text format.
IMREAL =IMREAL(inumber) Returns real coefficients of complex numbers in x + yi or x + yj text format.
IMSIN =IMSIN(inumber) Returns the sine of complex numbers in x + yi or x + yj text format.
IMSQRT =IMSQRT(inumber) Returns the square root of complex numbers 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