Author: Oscar Cronquist Article last updated on November 16, 2022

How to use the IMSECH function

The IMSECH function calculates the hyperbolic secant of a complex number in x + yi or x + yj text format.

The letter j is used in electrical engineering to distinguish between the imaginary value and the electric current.

The hyperbolic secant of a complex number is calculated like this:

C = x + yi

IMSECH(C) = (cosh x cos y - isinh x sin y) / (cosh2 x cos2 y+ sinh2 x sin2 y)

1. IMSECH Function Syntax

IMSECH(inumber)

Back to top

2. IMSECH Function Arguments

inumber Required. A complex number in x+yi or x+yj text format.

Back to top

3. IMSECH function example

How to use the IMSECH function

The image above demonstrates a formula in cell D3 that calculates the hyperbolic secant of a complex number specified in cell B3.

Formula in cell D3:

=IMSECH(B3)

3.1 Explaining formula

Step 1 - Populate arguments

IMSECH(inumber)

becomes

IMSECH(B3)

Step 2 - Evaluate the IMSECH function

IMSECH(B3)

becomes

IMSECH("1+2i")

and returns

-0.41314934426694-0.687527438655479i

Back to top