The Excel DEC2OCT function converts a decimal number to its octal equivalent. Syntax: =DEC2OCT (number, ) The DEC2OCT function syntax …

# 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 Dec2Hex function converts a decimal number into a Hexadecimal (Base 16) number Syntax: =DEC2HEX (number, ) The DEC2HEX …

The Excel DEC2BIN function converts a decimal number to its binary equivalent. Syntax: DEC2BIN(number, ) The DEC2BIN function syntax has …

The Excel CONVERT function converts a number in one measurement system to another. For example, you can use CONVERT to …

The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the …

The Microsoft Excel BIN2OCT function converts a binary number to an octal number. The BIN2OCT function is a built-in function …

The Excel Bin2Hex function converts a Binary (Base 2) number into a Hexadecimal (Base 16) number. Syntax: BIN2HEX(number, ) The …

The Excel BIN2DEC function converts a binary number to the decimal equivalent. The input number must contain only zeros and …

The BESSELY () is an engineering function which takes x, n as argument and returns the Bessel function, Yn(x) for …