How to use OCT2DEC Function in Excel
by The Excel Oct2Dec function converts an Octal (a base-8 number) into a decimal number Syntax:= OCT2DEC(number) The OCT2DEC function syntax has the following arguments: Number: …
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.
How to use OCT2BIN Function in Excel
The Excel Oct2Bin function converts an Octal (Base 8) number into a Binary (Base 2) number Syntax:= OCT2BIN(number, [places]) The OCT2BIN function syntax has the …
How to use IMTAN Function in Excel
The IMTAN function returns the tangent of a complex number in x + yi or x + yj text format. The tangent of a complex …
How to use IMSUM Function in Excel
The IMSUM function returns the sum of two or more complex numbers in x + yi or x + yj text format. When adding complex …
How to use IMSUB Function in Excel
The IMSUB function returns the difference of two complex numbers in x + yi or x + yj text format. When subtracting complex numbers, the …
How to use IMSQRT Function in Excel
The IMSQRT function returns the square root of a complex number in x + yi or x + yj text format Syntax:= IMSQRT(inumber) The IMSQRT …
How to use IMSINH Function in Excel
The IMSINH function returns the hyperbolic sine of a complex number in x+yi or x+yj text format Syntax:= IMSINH(inumber) The IMSINH function syntax has the …
How to use IMSIN Function in Excel
The IMSIN function returns the sine of a complex number in x + yi or x + yj text format Syntax:= IMSIN ( inumber ) The IMSIN …
How to use IMSECH Function in Excel
The IMSECH function returns the hyperbolic secant of a complex number in x+yi or x+yj text format. The hyperbolic secant of a complex number is …
How to use IMSEC Function in Excel
The Excel Imsec function returns the secant of a supplied complex number Syntax:= IMSEC(inumber) The IMSEC function syntax has the following arguments: Inumber Required. A …