The IMDIV function in Excel is used to divide complex numbers. It takes two complex numbers as arguments and returns the result of dividing the first complex number by the second complex number.


=IMDIV(Complex_num1, Complex_num2)

Complex_num1 The first complex number that will be divided.
Complex_num2 The second complex number which will divide the first complex number.


When working with complex numbers in Excel, the IMDIV function proves to be a handy tool for performing division operations on these numbers. It simplifies the process of dividing one complex number by another, eliminating the need for manual calculations or complex formulas. Complex numbers are often encountered in fields like engineering, physics, and mathematics, making IMDIV a valuable function in various scenarios where complex arithmetic is involved. By providing the two complex numbers you wish to divide, IMDIV swiftly computes the division result, saving time and effort in complex arithmetic operations.


Suppose you have two complex numbers in the format a+bi, and you want to divide them. If z1 = 3+2i and z2 = 1-i, the IMDIV formula would be as follows:

=IMDIV(3+2i, 1-i)

This will return the result of dividing the complex number 3+2i by the complex number 1-i.

Another example could be: If z1 = 4-2i and z2 = 2+3i, you can divide these complex numbers using the IMDIV function:

=IMDIV(4-2i, 2+3i)

This formula will give you the division result of the complex number 4-2i by the complex number 2+3i.


How does the IMDIV function handle complex number division?

The IMDIV function handles complex number division by applying the standard rules of complex arithmetic. It divides the first complex number by the second complex number, taking into account the real and imaginary parts of each number to determine the division result.

Can the IMDIV function handle complex numbers in polar form?

No, the IMDIV function works with complex numbers in the standard algebraic form a+bi, where 'a' represents the real part and 'b' represents the imaginary part. It does not support complex numbers in polar form (r∠θ).

What happens if I input invalid complex numbers into the IMDIV function?

If invalid complex numbers are provided as inputs to the IMDIV function (e.g., missing parts, incorrect formatting), Excel may return an error or incorrect result. It is important to ensure that the complex numbers are entered correctly to obtain accurate division results.

Related functions