Documentation/Calc Functions/ACOT

    From The Document Foundation Wiki


    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.

    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 LibreOffice functions:

    ACOS

    ASIN

    ATAN

    ATAN2

    COT

    ODF standard:

    Section 6.16.5, part 2

    Related (or similar) Excel functions:

    ACOT since v.2013.