The Excel Oct2Dec function converts an Octal (a base-8 number) into a decimal number Syntax:= OCT2DEC(number) The OCT2DEC 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 Oct2Bin function converts an Octal (Base 8) number into a Binary (Base 2) number Syntax:= OCT2BIN(number, ) The …

The IMTAN function returns the tangent of a complex number in x + yi or x + yj text format. …

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

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

The IMSINH function returns the hyperbolic sine of a complex number in x+yi or x+yj text format Syntax:= IMSINH(inumber) The …

The IMSECH function returns the hyperbolic secant of a complex number in x+yi or x+yj text format. The hyperbolic secant …

The Excel Imsec function returns the secant of a supplied complex number Syntax:= IMSEC(inumber) The IMSEC function syntax has the …