ACOT function
ACOT returns the angle, in radians, whose cotangent is the number you give it. The result falls between 0 and PI, so a negative input gives an answer above half of PI.
Example
Read it as a sentence: find the angle, in radians, whose cotangent is 1.
A
B
C
D
1
0.785398163397448
2
3
Syntax
ACOT(number)
-
number(required) - Any real number.
Returns: The angle in radians, between 0 and PI.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ACOT(0.5) | 1.107148718 | Positive |
=ACOT(0) | 1.570796327 | Zero |
=ACOT(-0.5) | 2.034443936 | Negative |
=ACOT(2) | 0.463647609 | Larger value |
=ACOT("0.5") | 1.107148718 | Text number "0.5" |
=ACOT(TRUE) | 0.785398163 | TRUE |
=ACOT("abc") | #VALUE! | Non-numeric text |
=ACOT(Data!E4) | #DIV/0! | Error cell propagates |
The Data sheet these formulas read
A cell that starts with = holds that formula.
E
1
5
2
abc
3
TRUE
4
=1/0
Data
Watch out for
- Result is between 0 and PI, so ACOT of a negative number is above PI/2.
Where it works
- Excel
- ACOT arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .