COTH function
COTH returns the hyperbolic cotangent of a number, mainly for technical models. It is the function that ACOTH reverses, and an input of zero returns #DIV/0!.
Example
Read it as a sentence: find the hyperbolic cotangent of 1.
A
B
C
D
1
1.31303528549933
2
3
Syntax
COTH(number)
-
number(required) - Any number except zero.
Returns: The hyperbolic cotangent.
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 |
|---|---|---|
=COTH(0.5) | 2.163953414 | Positive |
=COTH(-0.5) | -2.163953414 | Negative |
=COTH(2) | 1.037314721 | Larger value |
=COTH("0.5") | 2.163953414 | Text number "0.5" |
=COTH(TRUE) | 1.313035285 | TRUE |
=COTH({0.1,0.2}) | 10.03331113 | Array constant spills |
=COTH(0) | #DIV/0! | Zero |
=COTH("abc") | #VALUE! | Non-numeric text |
Watch out for
- Zero returns #DIV/0!.
Where it works
- Excel
- COTH 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 .