IMCONJUGATE Function in LibreOffice Calc — Tested Examples
An explanation of LibreOffice Calc IMCONJUGATE, including tested formulas, examples, expected results and common mistakes.
Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means
Returns the complex conjugate of a complex number. The complex conjugate leaves the real component unchanged and negates the imaginary one: 3+4i becomes 3−4i.
Syntax and arguments
=IMCONJUGATE(Complex_number)
LibreOffice Calc formulas generally separate arguments with semicolons (;).
| Argument | Explanation |
|---|---|
Complex number |
The complex number |
Worked examples
Example 1: Flip the sign of the imaginary part
=IMCONJUGATE("3+4i")
Expected result: 3-4i. This value was returned in the LibreOffice Calc 25.2 test.
Example 2: Conjugate a complex value with negative imaginary component
=IMCONJUGATE("2-3i")
Expected result: 2+3i. This value was returned in the LibreOffice Calc 25.2 test.
How to interpret the result
The complex conjugate leaves the real component unchanged and negates the imaginary one: 3+4i becomes 3−4i.
Mistakes and troubleshooting
- Check inputs and assumptions: Use a supported text representation such as “3+4i”; arbitrary strings are not valid complex numbers.
- Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
- Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.
Related functions
Tested version and primary reference
2 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.