Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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

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 .