The Excel IMARGUMENT function returns the argument θ, (an angle expressed in radians), of a supplied complex number. θ is …
Category: Engineering functions
The Excel Engineering Functions perform the most commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases. Engineers may also find the Excel Math and Trig functions useful.
In the tables below, the Excel Engineering functions have been grouped into categories, to help you to find the function you need. Selecting a function name will take you to a full description of the function with examples of use.
The Excel IMAGINARY function returns the imaginary coefficient of a complex number given in the form x + yi or …
The Excel IMABS function returns the absolute value of a complex number in the form x + yi or x …
The Excel HEX2OCT function converts a hexadecimal number to its octal equivalent. Syntax: HEX2OCT(number, ) The HEX2OCT function syntax has …
The Excel Hex2Dec function converts a hexadecimal (a base-16 number) into a decimal number. Syntax: =HEX2DEC (number) The HEX2DEC function …
The Excel Hex2Bin function converts a Hexadecimal (Base 16) number into a Binary (Base 2) number Syntax: HEX2BIN(number, ) The …
The GESTEP function is used to compare if the given number is greater than or equal to the other number. …
The Excel ERFC function calculates the Complementary Error Function, integrated between a supplied lower limit and infinity. The Complementary Error …
In mathematics, the error function (also called the Gauss error function or ERF) is a special, non-elementary function that occurs …
The DELTA function tests whether two values are equal. It returns 1 if number1 = number2; returns 0 otherwise. You …