Quick Navigation
IMCONJUGATE Function
Summary
The Excel IMCONJUGATE function returns the complex conjugate of a complex number provided in x+yi or x+yj format. This mathematical operation flips the sign of the imaginary component while keeping the real part unchanged.
Syntax
IMCONJUGATE(inumber)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| inumber | Complex Number |
Yes | A complex number entered as text in x+yi or x+yj format |
Using the IMCONJUGATE Function
IMCONJUGATE is vital for complex number calculations in engineering, physics, and mathematics. The complex conjugate operation is fundamental for computing magnitudes, performing divisions, and many other complex arithmetic operations.
Common IMCONJUGATE Examples
Basic Complex Conjugate
=IMCONJUGATE("3+4i")Returns "3-4i" - flips the sign of the imaginary part
Negative Imaginary Example
=IMCONJUGATE("5-2i")Returns "5+2i" - changes negative imaginary to positive
Using COMPLEX Function
=IMCONJUGATE(COMPLEX(7,3))Converts real/imaginary coefficients to complex number first, then finds conjugate (returns "7-3i")
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: inumber is not a valid complex number
Solution: Ensure proper format: use "x+yi" or "x-yi" with correct syntax
#NUM! error
Cause: Invalid complex number format
Solution: Check for correct i/j notation and numeric values
Notes
- Use COMPLEX function to create complex numbers from separate real/imaginary parts
- Complex conjugates are essential for calculating complex number magnitude: =IMABS(number) = SQRT(IMCONJUGATE(number)*number)
- Supports both Cartesian forms with i or j imaginary units
- Pure real numbers return themselves as conjugate
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+