How to Use ACOT function in Google Sheets in 2020?

ACOT functionThe ACOT function returns the inverse cotangent of a value in radians.

Parts of an ACOT function

ACOT(value)

Part
Description
Notes

value
The value for which to calculate the inverse cotangent.

Values must be a number.

Sample formulas

ACOT(0)

ACOT(-1)

ACOT(A1)

Notes

ACOT returns results that are between 0 and π (pi).
ACOT is sometimes written as “arccot” or “cot-1(x)” in mathematics or other programs.
Use the DEGREES function to convert the result of ACOT from radians to degrees.

Examples

This example shows the inverse cotangent of numbers in radians:

A
B

1
Formula
Result

2
=ACOT(4)
0.2449786631

3
=ACOT(-4)
-0.2449786631

4
=ACOT(0)
1.570796327

This example shows the inverse cotangent of numbers converted to degrees:

A
B
C

1
Data
Formula
Result

2
4
=DEGREES(ACOT(A2))
14.03624347

3
-4
=DEGREES(ACOT(A3))
-14.03624347

4
0
=DEGREES(ACOT(A4))
90

Related functions

ACOTH: The ACOTH function returns the inverse hyperbolic cotangent of a value in radians.
COT: The COT function returns the cotangent of an angle provided in radians.
COTH: The COTH function returns the hyperbolic cotangent of any real number.
ATANH: The ATANH function returns the inverse hyperbolic tangent of a number.
ATAN: The ATAN function returns the inverse tangent of a value in radians.
ASINH: The ASINH function returns the inverse hyperbolic sine of a number.
ASIN: The ASIN function returns the inverse sine of a value in radians.
ACOSH: The ACOSH function returns the inverse hyperbolic cosine of a number.
ACOS: The ACOS function returns the inverse cosine of a value in radians.
DEGREES: The DEGREES function converts an angle value in radians to degrees.
RADIANS: The RADIANS function converts an angle value in degrees to radians.
PI: The PI function returns the value of pi to 9 decimal places.