IMCONJUGATE Function in Excel – Get the complex conjugate of a complex number

IMCONJUGATE Function in Excel returns the complex conjugate of a supplied complex number.

The complex conjugate of the complex number, z = x + iy is x-iy

 

Syntax of IMCONJUGATE Function in Excel 

IMCONJUGATE( inumber )

Where inumber argument is a Complex Number.

 

Example of IMCONJUGATE Function in Excel

Formula

IMCONJUGATE Function in Excel 1

  • From Row number 2 to 5 IMCONJUGATE Function takes up complex number as a reference
  • In row number 6 IMCONJUGATE Function takes up complex number(imaginary component) as a value which should be enclosed in double quotes
  • In row number 7 IMCONJUGATE Function takes up real component as a value which returns 4 since there is no imaginary component.

 

Result

IMCONJUGATE Function in Excel 2

NOTE: #NUM! – Error occurs if,

  • supplied inumber argument is not recognized as a complex number.

previous-small IMCONJUGATE Function in Excel                                                                                                                next_small IMCONJUGATE Function in Excel