ID EN
#Engineering

IMCOT

Excel Functions

Get cotangent of complex number.

Syntax

EXCEL
=IMCOT(complex_num)

Arguments

Parameter Description
complex_num The complex number in the form "x+yi".

Return Value

The cotangent of the complex number.

Details

The Excel IMCOT function returns the cotangent of a complex number. For example, given "3+4i" as input, the function returns "-0.000187588-1.000644392i" as output. In math, the cotangent of a complex number is defined using the complex sine and cosine functions. In Excel, the cotangent of a complex number is equivalent to the following formula. The cotangent is the reciprocal of the complex tangent function.

Examples

Example 1

The Excel IMCOT function returns the cotangent of a complex number. For example, given "3+4i" as input, the function returns "-0.000187588-1.000644392

EXCEL
=IMCOT("3+4i") // returns -0.000187588-1.000644392i
Explanation

In Excel, the cotangent of a complex number is equivalent to the following formula.

EXCEL
=IMDIV(IMCOS(z),IMSIN(z)) // equivalent to IMCOT(z)

See Also

IMTAN IMCOS IMSIN COMPLEX