Engineering Functions

Below listed are the various engineering functions of Microsoft Excel.

Bin2dec():

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

Bin2hex():

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

Bin2oct():

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

Convert():

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

Dec2bin():

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

Dec2hex():

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

Dec2oct():

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

Delta():

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

Gestep():

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

Hex2bin():

HEX2BIN function converts a hexadecimal number to a binary number.

Hex2dec():

HEX2DEC function converts a hexadecimal number to a decimal number.

Hex2oct():

HEX2OCT function converts a hexadecimal number to an octal number.

Imabs():

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

Imaginary():

IMAGINARY function returns the imaginary coefficient of a complex number.

Imargument():

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

Imconjugate():

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

Imcos():

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

Imdiv():

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

Imexp():

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

Imln():

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

Imlog10():

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

Imlog2():

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

Impower():

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

Improduct():

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

Imreal():

IMREAL function returns the real coefficient of a complex number.

Imsin():

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

Imsqrt():

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

Imsub():

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

Imsum():

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

Oct2bin():

OCT2BIN function converts an octal number to a binary number.

Oct2dec():

OCT2DEC function converts an octal number to a decimal number.

Oct2hex():

OCT2HEX function converts an octal number to a hexadecimal number.