IMDIVReturns one complex number divided by another.
dividend – The complex number to be divided.
divisor – The complex number to divide by.
The division between two complex numbers is defined as follows:
You can divide two complex numbers only if they have the same suffix (i or j). For example, you can’t do IMDIV(“4+3i”, “1+2j”).
COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.
IMREAL: Returns the real coefficient of a complex number.
IMAGINARY: Returns the imaginary coefficient of a complex number.
IMPRODUCT: Returns the result of multiplying a series of complex numbers together.
=IMDIV(COMPLEX(11, 16), COMPLEX(3, 2))