ExcelFlux

IMCONJUGATE function

the complex conjugate of a complex number.

Engineering

Where can you use it?

Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.

Scenario in the workbook

Reverse the sign of the imaginary part. The real part stays the same.

A worked example from the workbook

RowA
6Input
73+4i
82-3i
92i
Record 1
=IMCONJUGATE(A7)

Expected result3-4i

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=IMCONJUGATE("3+4i")
Turkish Excel · tr-TR
=SANEŞLENEK("3+4i")

Expected result

“3-4i”

Worked examples

Reverse the sign of the imaginary part. The real part stays the same.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 3+4i
8 2-3i
9 2i
Case Formula Expected result
Record 1 =IMCONJUGATE(A7) 3-4i
Record 2 =IMCONJUGATE(A8) 2+3i
Record 3 =IMCONJUGATE(A9) -2i
Microsoft Excel reference