IMCONJUGATE function
IMCONJUGATE returns the complex conjugate of a complex number as text. It flips the sign of the imaginary part, so 3+4i becomes 3-4i. A complex number is one written in x+yi form.
Example
Read it as a sentence: flip the sign of the imaginary part of 3+4i, which gives 3-4i.
A
B
C
D
1
3-4i
2
3
Syntax
IMCONJUGATE(inumber)
-
inumber(required) - A complex number as text, like "3+4i".
Returns: The complex conjugate as text.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=IMCONJUGATE("3+4i") | 3-4i | "3+4i" |
=IMCONJUGATE("3+4j") | 3-4j | Suffix j |
=IMCONJUGATE(5) | 5 | Pure real number 5 |
=IMCONJUGATE("5") | 5 | Pure real text "5" |
=IMCONJUGATE("i") | -i | Pure imaginary "i" |
=IMCONJUGATE("-2i") | 2i | "-2i" |
=IMCONJUGATE("3+4I") | #NUM! | Uppercase I |
=IMCONJUGATE("abc") | #NUM! | Invalid text |
Watch out for
- Result is text.
Where it works
- Excel
- IMCONJUGATE is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .