English

# Engineering Functions

Below listed are the various engineering functions of Microsoft Excel.

BIN2DEC function is used to convert a binary number to a decimal number.

BIN2HEX function is used to convert a binary number to a hexadecimal number.

BIN2OCT function is used to convert a binary number to an octal number.

CONVERT function is used to convert the given value from one unit to the other unit.

DEC2BIN function is used to convert a decimal number to a binary number.

DEC2HEX function is used to convert a decimal number to a hexadecimal number.

DEC2OCT function is used to convert a decimal number to an octal number.

DELTA function is used to check whether the given two numbers are exactly the same.

GESTEP function is used to compare if the given number is greater than or equal to the other number.

HEX2BIN function converts a hexadecimal number to a binary number.

HEX2DEC function converts a hexadecimal number to a decimal number.

HEX2OCT function converts a hexadecimal number to an octal number.

IMABS function returns the absolute value (modulus) of a complex numbers in the text format of x+yi or x+yj.

IMAGINARY function returns the imaginary coefficient of a complex number.

IMARGUMENT function returns the argument ?, which is an angle expressed in radians of the given complex number.

IMCONJUGATE function returns the conjugate of the given complex number in the text format of x+yi or x+yj.

IMCOS function returns the cosine of the given complex number in the text format of x+yi or x+yj.

IMDIV function returns the quotient of two complex numbers in x + yi or x + yj text format.

IMEXP function returns the exponential of a complex number in x+yi or x+yj text format.

IMLN function returns the natural logarithm of a complex number in the text format of x+yi or x+yj.

IMLOG10 function returns the common logarithm (base10) of a complex number in the text format of x+yi or x+yj.

IMLOG2 function returns the base-2 logarithm of a complex number in the text format of x+yi or x+yj.

IMPOWER function returns the complex number raised to a given power in x + yi or x + yj text format.

IMPRODUCT function calculates the product of two or more complex numbers.

IMREAL function returns the real coefficient of a complex number.

IMSIN function returns the sine of the complex number in x+yi or x+yj text format.

IMSQRT function returns the square root of a complex number in the text format of x+yi or x+yj.

IMSUB function calculates the difference of two complex numbers in x+yi or x+yj text format.

IMSUM function calculates the sum of two or more complex numbers in the text format of x+yi or x+yj.

OCT2BIN function converts an octal number to a binary number.

OCT2DEC function converts an octal number to a decimal number.

OCT2HEX function converts an octal number to a hexadecimal number.