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

How to use the IMSEC function

The IMSEC function calculates the 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 secant of a complex number is calculated like this:

C = x + yi

IMSEC(C) = (cos x cos y + isin x sinh y) / (cos2 x cosh2 y+ sin2 x sinh2 y)

1. IMSEC Function Syntax

IMSEC(inumber)

Back to top

2. IMSEC Function Arguments

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

Back to top

3. IMSEC function example

How to use the IMSEC function

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

Formula in cell D3:

=IMSEC(B3)

3.1 Explaining formula

Step 1 - Populate arguments

IMSEC(inumber)

becomes

IMSEC(B3)

Step 2 - Evaluate the IMSEC function

IMSEC(B3)

becomes

IMSEC("1+2i")

and returns

0.151176298265577+0.226973675393722i

Back to top