English

# 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.