The IMCONJUGATE function returns the complex conjugate of a complex number in x + yi or x + yj text format.

Syntax

=IMCONJUGATE(inumber)

Arguments

Argument Description
inumber A complex number for which you want the conjugate

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Examples

  A B C D
1 Data Formula Result Notes
2 3+4i =IMCONJUGATE(A2) 3-41 Complex conjugate of 3+4i
3   =IMCONJUGATE(“3+4i”) 3-4i  
4   =IMARGUMENT(“3i”) -3i  
5   =IMARGUMENT(COMPLEX(4,1)) 4-i  

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled

The conjugate of a complex number is calculated: 

    \[ \text{IMCONJUGATE}(x + yi) = \bar{z} = (x - yi)  \]