Related Function:

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.

Syntax

=ACOT(number)

Arguments

Argument Description
number Number is the cotangent of the angle you want – this must be a real number

Examples

  A B C
1 Formula Result Notes
2 =ACOT(2) 0.4636 Returns the arccotangent of 2, in radians
3 =ACOT(1) 0.7853  
4 =ACOT(-2) 2.6779  
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

trigonometry_triangleThe 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:   

    \[    A = arccot \left( \frac b{a} \right)    \]

See Wikipedia for more information on Inverse Trigonometric Functions.