Documentation/Calc Functions/ACOT

Other languages:

ACOT

Mathematical

Summary:

Calculates the inverse trigonometric cotangent (arccotangent or arccot) of a real number. The value returned is the principal value and lies in the range (0, π) radians.

ACOT(Number)

Returns:

Returns a real number in the range (0, π) that is the inverse trigonometric cotangent of Number in radians.

Arguments:

Number is a real number, or a reference to a cell containing that number, whose inverse trigonometric cotangent is to be calculated.

• If Number is non-numeric, then ACOT reports a #VALUE! error.

Additional details:

• To return the angle in degrees, use the DEGREES function.
• Alternatively multiply by 180/PI() to convert the result from radians to degrees.

The figure below illustrates the function ACOT.

ACOT function

Examples:

Formula Description Returns
=ACOT(−1) Inverse trigonometric cotangent of -1. 2.35619449019234 (3π/4)
=ACOT(0.5) Inverse trigonometric cotangent of 0.5. 1.10714871779409
=DEGREES(ACOT(0.5)) Inverse trigonometric cotangent of 0.5, converted to degrees. 63.434948822922
=ACOT(0.5)*180/PI() Inverse trigonometric cotangent of 0.5, converted to degrees. 63.434948822922
=DEGREES(ACOT(COT(RADIANS(60))) An angle of 60° is converted to radians, its cotangent is taken, then the inverse cotangent of that value is calculated, and finally the result is converted back to degrees. 60

Related (or similar) Excel functions:

ACOT since v.2013.