How to use IMCONJUGATE Function in Excel

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:

IMCONJUGATE Function - How to use IMCONJUGATE Function in Excel

Syntax:  =IMCONJUGATE(A2)

Result:

IMCONJUGATE Function in Excel 1 - How to use IMCONJUGATE Function in Excel

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: IMCONJUGATE Function in Excel - How to use IMCONJUGATE Function in Excel

  • 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
READ:  How to use HEX2BIN Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *