IMCOT

IMCOT(inumber)

Returns the cotangent ratio of a complex number.

inumberThe complex number.

REMARKS
* If "inumber" is not in the form x + yi or x + yj, then #NUM! is returned.
* If "inumber" is not text, then #VALUE! is returned.
* You can use the COT function to return the cotangent ratio of an angle.
* You can use the IMCSC function to return the cosecant ratio of a complex number.
* You can use the IMSEC function to return the secant ratio of a complex number.
* You can use the COMPLEX function to convert real and imaginary coefficients into a complex number.
* You can use the IMCOS function to return the cosine ratio of a complex number.
* You can use the IMSIN function to return the sine ratio of a complex number.
* You can use the IMTAN function to return the tangent ratio of a complex number.
* You can use the TEXT function to return the number as a formatted text string.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=IMCOT("1+i") = 0.217621561854403-0.868014142895925i
2=IMCOT("i") = -1.31303528549933i
3=TEXT(IMCOT("i"), "0.000") = -1.31303528549933i
4=IMCOT("text") = #NUM!


© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top