Documentation/Calc Functions/ACOT
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
ACOT
Category:
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.
Syntax:
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.
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 LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
ACOT since v.2013.