COT function
COT returns the cotangent of an angle in radians, which is 1 divided by the tangent. An angle of 0 returns a #DIV/0! error because the tangent is zero there.
Example
Read it as a sentence: find the cotangent of 1 radian.
A
B
C
D
1
0.642092615934331
2
3
Syntax
COT(number)
-
number(required) - An angle in radians. Must not be zero.
Returns: The cotangent (1 divided by the tangent).
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 |
|---|---|---|
=COT(0.5) | 1.830487722 | Positive |
=COT(-0.5) | -1.830487722 | Negative |
=COT(2) | -0.457657554 | Larger value |
=COT("0.5") | 1.830487722 | Text number "0.5" |
=COT(TRUE) | 0.642092616 | TRUE |
=COT({0.1,0.2}) | 9.966644423 | Array constant spills |
=COT(0) | #DIV/0! | Zero |
=COT("abc") | #VALUE! | Non-numeric text |
Watch out for
- An angle of 0 returns #DIV/0!.
Where it works
- Excel
- COT 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 .