SECH function
SECH returns the hyperbolic secant of a number, which is 1 divided by the hyperbolic cosine. It is a niche function, rarely needed outside math and engineering work.
Example
A
B
C
D
1
0.648054273663885
2
3
Syntax
SECH(number)
-
number(required) - Any number or a reference to one.
Returns: The hyperbolic secant.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SECH(0.5) | 0.886818884 | Positive |
=SECH(0) | 1 | Zero |
=SECH(-0.5) | 0.886818884 | Negative |
=SECH(2) | 0.265802229 | Larger value |
=SECH("0.5") | 0.886818884 | Text number "0.5" |
=SECH(TRUE) | 0.648054274 | TRUE |
=SECH("abc") | #VALUE! | Non-numeric text |
=SECH(Data!E4) | #DIV/0! | Error cell propagates |
The Data sheet these formulas read
A cell that starts with = holds that formula.
E
1
5
2
abc
3
TRUE
4
=1/0
Data
Where it works
- Excel
- SECH 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 .