Practice free

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

Practice this in the app

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.

FormulaExcel showsCase
=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.

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 .