Sech Function

Calculates the secant


The function \(Sech\) calculates the secant of the argument.

\(Sech\) returns the secant of real or complex numbers. The argument can be a single number or a data field. For data fields, the secant of each element is calculated and the results are returned in a data field of the same size.

Six for real numbers


The angle is given in degrees (full circle = 360°) or radians / radians (full circle = 2 · p). The unit of measure used is set in the toolbar with the DEG or RAD buttons or with an optional parameter. The setting in the toolbar applies to the entire worksheet.

Optional Parameter

Optionally, a second parameter can be specified with the keywords DEG or RAD to set the unit of measure for this function call. The specification of the parameter has priority over the global setting in the toolbar. It allows you to use different units of measure on a spreadsheet, regardless of the default toolbar setting.


Sech (value)

Sech (value, RAD)

Sech (value, DEG)


Sech for complex numbers

For complex numbers, the result is always given as radians, regardless of the default setting in the toolbar. The result is also a complex number.


Sech (re + im)


Sech(3 + 4i)= -0.0653+0.0752i