The IMCOT function returns the cotangent of a complex number in x+yi or x+yj text format.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.




Argument Description
inumber A complex number for which you want the cotangent

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.


  A B C D
1 Data Formula Result Notes
2 3+4i =IMCOT(A2) -0.000187587737983659-1.00064439247156i Returns the cotangent of a complex number 3+4i
3   =IMCOT(“3+4i”) -0.000187587737983659-1.00064439247156i  
4   =IMCOT(“2-i”) 0.253182007063936-0.928132757303418i  
5   =IMCOT(COMPLEX(4,1)) ‘0.253182007063936-0.928132757303418i  

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied inumber argument is a logical value
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number

The cotangent of a complex number is defined as the inverse of the tangent, and is calculated:

cot(z) = \frac{1}{tan(z)}


cot(z) = \frac{cos(z)}{sin(z)}

See Wikipedia for more information on complex numbers.