Purpose
Return value
Syntax
=IMCOT(complex_num)
- complex_num - The complex number in the form “x+yi”.
Using the IMCOT function
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 .
Purpose
Return value
Syntax
=IMCSC(complex_num)
- complex_num - The complex number in the form “x+yi”.
Using the IMCSC function
The Excel IMCSC function returns the cosecant of a complex number. For example, given “4+3i” as input, the function returns “-0.075489833+0.064877471i” as output.
=IMCSC("4+3i") // returns -0.075489833+0.064877471i
Explanation
In math, the complex cosecant function is the reciprocal of the complex sine function .
In Excel, the complex cosecant function is equivalent to the following formula.
=IMDIV(COMPLEX(1,0),IMSIN(z)) // equivalent to IMCSC(z)
