Excel functions / Math
COSH function
The hyperbolic cosine of a number.
Syntax
=COSH(number)
Arguments
number: Any number.
When to use it
COSH gives the hyperbolic cosine of a number, (e^x + e^-x)/2: the curve a chain or cable makes when it hangs between two points.
Examples
The sag of a cable
A B C 1 x 2 0.5 0.1276 In C2:
=COSH(A2)-1→ 0.1276
Common mistakes
- Large numbers. COSH grows like EXP: above about 710 it is too large and gives #NUM!.
COSH in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: COSH
- Danish: COSH
- Dutch: COSH
- Finnish: COSH
- French: COSH
- German: COSHYP
- Hungarian: COSH
- Italian: COSH
- Norwegian: COSH
- Polish: COSH
- Portuguese (Brazil): COSH
- Portuguese (Portugal): COSH
- Russian: COSH
- Spanish: COSH
- Swedish: COSH
- Turkish: COSH