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
| Row | A |
|---|---|
| 6 | Input |
| 7 | 3+4i |
| 8 | 2-3i |
| 9 | 2i |
Record 1
=IMCONJUGATE(A7)Expected result3-4i
See the inputs and instructions for all 3 examplesCopyable 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 |