Returns one complex number divided by another.

Sample Usage

IMDIV("11+16i", "3+2i")

IMDIV("4+2j", 2)


IMDIV(dividend, divisor)

  • dividend - The complex number to be divided.
  • divisor - The complex number to divide by.


  • The division between two complex numbers is defined as follows:
    • IMDIV Equation
  • 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").

See also

  • 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.


1 A B
2 Formula Result
3 =IMDIV("11+16i", "3+2i") 5+2i
4 =IMDIV("4+2j", 2) 2+j
5 =IMDIV(COMPLEX(11, 16), COMPLEX(3, 2)) 5+2i
Was this helpful?
How can we improve it?