ID EN
#Engineering

IMSECH

Excel Functions

Get hyperbolic secant of a complex number

Syntax

EXCEL
=IMSECH(complex_num)

Arguments

Parameter Description
complex_num The number to get the inverse hyperbolic secant of.

Return Value

The hyperbolic secant of a complex number

Details

The Excel IMSECH function returns the hyperbolic secant of a complex number. Given "1+1.5707963267949i" as input, the function returns "-3.9E-15-0.85092i" as output. The complex hyperbolic secant function is the reciprocal of the complex hyperbolic sine function. In Excel, the function's output is equivalent to the following formula.

Examples

Example 1

The Excel IMSECH function returns the hyperbolic secant of a complex number. Given "1+1.5707963267949i" as input, the function returns "-3.9E-15-0.850

EXCEL
=IMSECH(COMPLEX(1, PI()/2)) // returns -3.9E-15-0.85092i
Explanation

In Excel, the function's output is equivalent to the following formula.

EXCEL
=IMDIV(1,IMCOSH(z)) // equivalent to IMSECH(z)

See Also

IMCOSH