Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
COSH
Returns the hyperbolic cosine of a number.
Rarely usedDifficulty 1300 · ProficientUsage rank #300 of 520
When to use it
Hyperbolic cosine: (e^x + e^-x)/2. The shape of a hanging cable.
The shape of it
- Syntax
=COSH(number)
Worked examples
Zero
=COSH(0) → 1
Minimum value.
One
=COSH(1) → 1.543080635
One.
Negative
=COSH(-1) → 1.543080635
Even function: symmetric.
Worth knowing
- Catenary: y = a*COSH(x/a).
- COSH^2 - SINH^2 = 1, the hyperbolic identity.
- ACOSH inverts it for x ≥ 1.
Where it goes wrong
- Overflows to #NUM! above about 710.
- Not an angle function; input is a plain number.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.