IMCONJUGATE Function in Excel returns the complex conjugate of a supplied complex number.
Syntax of IMCONJUGATE Function in Excel
Where inumber argument is a Complex Number.
Example of IMCONJUGATE Function in Excel
- 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.
NOTE: #NUM! – Error occurs if,
- supplied inumber argument is not recognized as a complex number.