Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .