Excel 2013+
Math & Trig
The Excel CSCH function returns the hyperbolic cosecant of a number — the reciprocal of the hyperbolic sine, 1/SINH. The argument is a plain number, not an angle.
Quick answer:
=CSCH(1) hyperbolic cosecant of 1 = approx 0.8509
Syntax
=CSCH(number)
| Argument | Description | |
|---|---|---|
number | Required | Any non-zero real number. CSCH is the reciprocal of SINH, so an argument of 0 returns a #DIV/0! error. |
How to use it
CSCH is simply 1/SINH(number), introduced in Excel 2013. There is no degree-vs-radian issue — you pass a plain number:
=CSCH(1) // approx 0.8509
=CSCH(2) // approx 0.2757
=CSCH(-1) // approx -0.8509 (odd function)
CSCH is an odd function. Use =1/SINH(x) in versions before Excel 2013.
Undefined at zero. Because SINH(0) is zero, =CSCH(0) returns a #DIV/0! error. Use any non-zero argument.
Try it: interactive demo
Live demo
Pick a CSCH example to see the formula and its result.
Result:
Practice workbook
Download the free CSCH practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.
Frequently asked questions
What is the hyperbolic cosecant?
It is the reciprocal of the hyperbolic sine:
CSCH(x) = 1/SINH(x). It is an odd function and is undefined at x = 0.Which Excel versions have CSCH?
CSCH was added in Excel 2013. In Excel 2010 and earlier, use
=1/SINH(x) instead.Why does CSCH(0) return an error?
The hyperbolic sine of 0 is zero, and dividing by zero is undefined, so
=CSCH(0) returns #DIV/0!. Use any non-zero argument.Does CSCH use degrees or radians?
Neither — CSCH takes a plain real number, not an angle. There is no degree-to-radian conversion for hyperbolic functions.
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class