The ACOT function returns the principal value of the arccotangent, or inverse cotangent, of a number.
- This function was introduced in Excel 2013 and so is not available in earlier versions.
|number||Number is the cotangent of the angle you want – this must be a real number|
|2||=ACOT(2)||0.4636||Returns the arccotangent of 2, in radians|
|5||=DEGREES(ACOT(0))||90||The DEGREES function is used to convert the function result from radians into degrees|
Note: If your angle is in degrees, you will need to convert it into radians before supplying it to the ACOT function. You can convert it, using the RADIANS function: =RADIANS(degrees)
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if the supplied number argument is not recognized as a numeric value|
The arccotangent is the inverse of the cotangent. Therefore, for the simple right-angle triangle at right, the arccotangent of the adjacent side (b), divided by the opposite side (a), is equal to the angle A. The arccotangent for the triangle at right is:
See Wikipedia for more information on Inverse Trigonometric Functions.