ExcelExcel 2013+
SECH function in Excel
Returns the hyperbolic secant of an angle
=SECH(number)SECH syntax and parameters
One argument, one required.
- numbernumberRequired
SECH examples
Formulas you'll actually reuse.
Hyperbolic secant — the reciprocal of COSH:
=SECH(B2)Result
0.6481SECH peaks at 1 when the input is 0:
=SECH(0)Result
1
SECH in Google Sheets
Same name — your formula ports as-is.
Try SECH in the playground
Edit the example — nothing to install.
Preloaded with the SECH formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ABSReturns the absolute value of a numberMathGoogle Sheets
- ACOSReturns the arccosine of a numberMathGoogle Sheets
- ACOSHReturns the inverse hyperbolic cosine of a numberMathGoogle Sheets
- ACOTReturns the arccotangent of a numberMathGoogle Sheets
- ACOTHReturns the hyperbolic arccotangent of a numberMathGoogle Sheets
- AGGREGATEReturns an aggregate in a list or databaseMathNo Google Sheets equivalent