The ACOT function in Excel calculates the arccot (inverse of cot) of a given number and returns the angle in radians between 0 and π. Arccot is inverse of cot.
ARCCOT(b/a)= θ
Arccot of the adjacent side – b, divided by the opposite side – a equal to the angle θ.
Syntax of ACOT Function in Excel
ACOT(number)
Where Argument number is a value between -1 and 1 which you need to calculate the arccot.
Example of ACOT Function in Excel
Formula
- From Row number 2 to 5 ACOT is calculated in radians for value between -1 and 1 that is being passed as input to the ACOT Function.
- In row number 6, ACOT is calculated in degree for the value 1 which is 45 degree
Note: if you want the value of ACOT Function to be calculated in degrees, then convert it in degrees using DEGREES Function as shown in 6th row.