This article describes the formula syntax and usage of the SECH function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Returns the hyperbolic secant of an angle.
The SECH function syntax has the following arguments.
Number Required. Number is the angle in radians for which you want the hyperbolic secant.
- 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.
- 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.
The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.
To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.
Top of Page