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: 4-2i
Syntax: =IMCONJUGATE(A7)
Result: j
Syntax: =IMCONJUGATE(A8)
Result: 3+7j
Syntax: =IMCONJUGATE(A9)
Result: 1.5-2i
Syntax: =IMCONJUGATE(A10)
Result: 4+3j
Syntax: =IMCONJUGATE(A11)
Result: 5+12i
Syntax: =IMCONJUGATE(A12)
Result: 100+30j
Syntax: =IMCONJUGATE(A13)
Result: 3-4j
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
