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

How to use the IMTAN function

The IMTAN function calculates the tangent 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.

1. IMTAN Function Syntax

IMTAN(inumber)

Back to top

2. IMTAN Function Arguments

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

Back to top

3. IMTAN function example

How to use the IMTAN function

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

Formula in cell D3:

=IMTAN(C3)

3.1 Explaining formula

Step 1 - Populate arguments

IMTAN(inumber1)

becomes

IMTAN(C3)

Step 2 - Evaluate the IMTAN function

IMTAN(C3)

becomes

IMTAN("1+1i")

and returns

0.271752585319512+1.08392332733869i

Back to top