Author: Oscar Cronquist Article last updated on September 23, 2022

How to use the IMCONJUGATE function

The IMCONJUGATE function calculates the complex conjugate 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. IMCONJUGATE Function Syntax

IMCONJUGATE(inumber)

Back to top

2. IMCONJUGATE Function Arguments

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

Back to top

3. IMCONJUGATE function example

How to use the IMCONJUGATE function

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

Formula in cell D3:

=IMCONJUGATE(C3)

The complex conjugate is calculated by changing the sign of the imaginary value of a complex number.

IMCONJUGATE(x+yi) = z̄ = (x-yi)

3.1 Explaining formula

Step 1 - Populate arguments

IMCONJUGATE(inumber)

becomes

IMCONJUGATE(C3)

Step 2 - Evaluate IMCONJUGATE function

IMCONJUGATE(C3)

becomes

IMCONJUGATE("9+12i")

and returns

"9-12i".

Back to top