COSH function
COSH computes the hyperbolic cosine of a number. It appears in curves like hanging cables and in some statistical formulas, and it is the function that ACOSH reverses.
Example
A
B
C
D
1
1.54308063481524
2
3
Syntax
COSH(number)
-
number(required) - Any number or a reference to one.
Returns: The hyperbolic cosine.
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 |
|---|---|---|
=COSH(0.5) | 1.127625965 | Positive |
=COSH(0) | 1 | Zero |
=COSH(-0.5) | 1.127625965 | Negative |
=COSH(2) | 3.762195691 | Larger value |
=COSH("0.5") | 1.127625965 | Text number "0.5" |
=COSH(TRUE) | 1.543080635 | TRUE |
=COSH("abc") | #VALUE! | Non-numeric text |
=COSH(711) | #NUM! | Overflow 711 |
Where it works
- Excel
- COSH is in every version of Excel from 2007 on.
- 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 .