# Excel Engineering Function Encyclopedia

Source: Internet
Author: User

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
Related Keywords:

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

## A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

• #### Sales Support

1 on 1 presale consultation

• #### After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

• Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.