- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - CSCH Function
Description
The CSCH function returns the hyperbolic cosecant of an angle specified in radians.
Syntax
CSCH (number)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The angle (in radians) that you want to calculate the hyperbolic cosecant of. | Required |
Notes
The value of the hyperbolic cosecant is given by the equation −
$$csch\left ( x \right ) = \frac{1}{\sinh \left ( x \right )} = \frac{2}{\left ( e^x-e^{-x} \right )}$$
If the angle is in degrees, convert it to radians by multiplying with by PI()/180 or use the RADIANS Function
=RADIANS (degrees)
The absolute value of Number must be less than 2^27.
If Number is outside its constraints, CSCH returns the #NUM! error value.
If Number is a non-numeric value, CSCH returns the #VALUE! error value.
CSCH (0) returns the #DIV/0! error value.
Applicability
Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements