CSCH function
CSCH returns the hyperbolic cosecant of a number, which is 1 divided by the hyperbolic sine. It is rarely needed outside math work, and zero returns #DIV/0!.
Example
Read it as a sentence: find the hyperbolic cosecant of 1.
A
B
C
D
1
0.850918128239322
2
3
Syntax
CSCH(number)
-
number(required) - Any number except zero.
Returns: The hyperbolic cosecant.
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 |
|---|---|---|
=CSCH(0.5) | 1.919034751 | Positive |
=CSCH(-0.5) | -1.919034751 | Negative |
=CSCH(2) | 0.275720565 | Larger value |
=CSCH("0.5") | 1.919034751 | Text number "0.5" |
=CSCH(TRUE) | 0.850918128 | TRUE |
=CSCH({0.1,0.2}) | 9.983352757 | Array constant spills |
=CSCH(0) | #DIV/0! | Zero |
=CSCH("abc") | #VALUE! | Non-numeric text |
Watch out for
- Zero returns #DIV/0!.
Where it works
- Excel
- CSCH 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 .