- 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 - SECH Function
Description
The SECH function returns the hyperbolic secant of an angle. The hyperbolic secant is the reciprocal of the hyperbolic cosine. Hence, the value of the hyperbolic secant is given by the equation −
$$\sinh \left ( x \right ) = \frac{1}{\cosh \left ( x \right )} = \frac{2}{e^x+e^{-x}}$$
Syntax
SECH (number)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | Number is the angle in radians for which you want the hyperbolic secant. | Required |
Notes
The absolute value of number must be less than 2^27
If the angle is in degrees, either multiply the angle by PI()/180 or use the RADIANS Function to covert the angle to radians
= RADIANS (degrees)
If number is outside of its constraints, SECH returns the #NUM! error value.
If number is a non-numeric value, SECH returns the #VALUE! error values.
Applicability
Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements