The IMCONJUGATE function returns the complex conjugate of a complex number in x + yi or x + yj text format.
Syntax: IMCONJUGATE( inumber )
The IMCONJUGATE function syntax has the following arguments:
 Inumber Required. A complex number for which you want the conjugate
Example: Let’s look at some Excel IMCONJUGATE function examples and explore how to use the IMCONJUGATE function as a worksheet function in Microsoft Excel:
Syntax: =IMCONJUGATE(A2)
Result:
Based on the Excel spreadsheet above, the following IMCONJUGATE examples would return:
Syntax: =IMCONJUGATE(A3)
Result: 2+i
Syntax: =IMCONJUGATE(A4)
Result: 8
Syntax: =IMCONJUGATE(A5)
Result: 3i
Syntax: =IMCONJUGATE(A6)
Result: 42i
Syntax: =IMCONJUGATE(A7)
Result: j
Syntax: =IMCONJUGATE(A8)
Result: 3+7j
Syntax: =IMCONJUGATE(A9)
Result: 1.52i
Syntax: =IMCONJUGATE(A10)
Result: 4+3j
Syntax: =IMCONJUGATE(A11)
Result: 5+12i
Syntax: =IMCONJUGATE(A12)
Result: 100+30j
Syntax: =IMCONJUGATE(A13)
Result: 34j
Note:
 Use COMPLEX to convert real and imaginary coefficients into a complex number.

The conjugate of a complex number is:
 If inumber is not recognized as a complex number, IMCONJUGATE Function returns #NUM! error.
 If inumber is a logical value, IMCONJUGATE Function returns #VALUE! Error