Purpose
Return value
Syntax
=IMCOT(complex_num)- complex_num - The complex number in the form "x+yi".
How to use
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.
=IMCOT("3+4i") // returns -0.000187588-1.000644392i
Explanation
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.
=IMDIV(IMCOS(z),IMSIN(z)) // equivalent to IMCOT(z)
The cotangent is the reciprocal of the complex tangent function.
Related functions
IMTAN Function
The Excel IMTAN function returns the tangent of a complex number. ...
IMCOS Function
The Excel IMCOS function returns the cosine of a complex number.
IMSIN Function
The Excel IMSIN function returns the sine of a complex number.
COMPLEX Function
The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj....
