Excel Engineering Function Encyclopedia

Engineering function

BesselI returns the modified Bessel function in (X)

BesselJ return Bessel function Jn (X)

Besselk returns the modified Bessel function kn (X)

bessely return Bessel function yn (X)

Xlfctbin2dec, Bin2dec converts a binary number to a decimal number

Bin2Hex converts a binary number to a hexadecimal number

BIN2OCT converts binary numbers to octal numbers

COMPLEX converts real and virtual coefficients to complex numbers

Convert converts a number in a unit of measure units into another metric unit of measure

Dec2bin converts a decimal number to a binary number

Dec2hex converts a decimal number to a hexadecimal number

DEC2OCT converts decimal numbers to octal numbers

DELTA detects whether two values are equal

ERF return Error function

ERFC return residual error function

Gestep detect if the number is greater than a threshold value

Hex2bin converts a hexadecimal number to a binary number

Hex2dec converts a hexadecimal number to a decimal number

HEX2OCT converts a hexadecimal number to an octal number

Imabs returns the absolute value of a complex number (modulo)

Imaginary returns the imaginary coefficients of complex numbers

Imargument returns the parameter theta, an angle in radians

Imconjugate returns the conjugate plural of a complex number

Imcos returns the cosine of a complex number

Imdiv returns a quotient of two plural

Imexp returns the exponent of a complex number

IMLN returns the natural logarithm of a complex number

IMLOG10 returns the common logarithms of the plural

IMLOG2 returns the 2-based logarithm of a complex number

Impower returns the integer power of a complex number

Improduct returns the product of two complex numbers

Imreal returns the real coefficient 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 two plural and

Oct2bin converts a octal number to a binary number

Oct2dec converts a octal number to a decimal number

Oct2hex converts a octal number to a hexadecimal number

Classification:

• Excel Tutorials