Typically, the conjugate appears in text with a horizontal bar over the complex number.
The conjugate is used to divide a complex number by another.
In other words, the divisor is converted into a real number which we know how to divide by.
This is equal to the following formula in Excel.
In practice, Excel provides the IMDIV function to perform complex division.
IMDIV Function
The Excel IMDIV function returns the quotient of two complex numbers.
IMREAL Function
The Excel IMREAL function returns the real part of a complex number.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary part of a complex number.
