In Excel, we use the** IMDIV** function for calculating the quotient value after dividing a complex number by another complex number. In the following figure, we have demonstrated the usage of this function. So, let’s get into the main article.

**Table of Contents**hide

## IMDIV Function: Syntax & Arguments

**⦿ Function Objective**

The **IMDIV **function returns the result after dividing a complex number by another complex number.

**⦿ Syntax**

`=IMDIV(inumber1, inumber2)`

**⦿ Arguments**

Argument |
Required/Optional |
Explanation |
---|---|---|

inumber1 |
Required | The first complex number is the dividend. |

inumber2 |
Required | The second complex number is the divisor. |

**⦿ Return Value**

It returns the quotient value after dividing two complex numbers and the result will be in text format.

** ****⦿ Version**

The **IMDIV **function is available in Excel 2007 and later versions.

## Excel IMDIV Function: 3 Examples

In the following examples, we demonstrated the usage of the** IMDIV** function in Excel. For creating this article, we have used the Microsoft Excel 365 version. However, you can use any other version at your convenience.

__Example-1__: Inserting Arguments Directly into IMDIV Function

In this section, we will insert the arguments directly into the** IMDIV** function and get the quotient values in the following table.

** Steps**:

- Type the following formula in cell
**B5**.

`=IMDIV("4+5i", "7-6i")`

Here, **“4+5i” **is the first complex number which is the dividend, and **“7-6i” **is the second complex number which is the divisor.

- Press
**ENTER**.

As a result, we will get the following result after dividing two complex numbers.

Similarly, we used different complex numbers for the rest of the results.

Finally, we used the following formula to get the result in cell **B10**.

`=IMDIV("1+5i","7+i")`

__Example-2__: Using Cell Reference for IMDIV Function in Excel

Here, we have two lists of complex numbers using which we will get the quotient value after dividing each complex number from one list by another complex number from the second list.

** Steps**:

- Type the following formula in cell
**D5**and press**ENTER**.

`=IMDIV(B5, C5)`

Here, **B5 **is the first complex number which is the dividend, and **C5 **is the second complex number which is the divisor.

- Drag down the
**Fill Handle**tool.

In this way, we get the results for the rest of the cells after dividing the complex numbers from column **inumber1 **by the complex numbers from column **inumber2**.

__Example-3__: Applying a Combination of COMPLEX and IMDIV Functions in Excel

In the following table, we can see that we have **4 **lists containing different real numbers. So, using these numbers and** the COMPLEX function** we will convert them into two complex numbers. Finally, **the IMDIV function** will give us the resultant value after dividing the first complex number by the second one.

** Steps**:

- Type the following formula in cell
**F5**and press**ENTER**.

`=IMDIV(COMPLEX(B5, C5), COMPLEX(D5, E5))`

__Formula Breakdown__

**COMPLEX(B5, C5) →**becomes**COMPLEX(1, 2) →**returns the complex number with a real number**1**and complex number**2**.**Output → 1+2i**

**COMPLEX(D5, E5) →**becomes**COMPLEX(3, 4) →**returns the complex number with a real number**3**and complex number**4**.**Output → 3+4i**

**IMDIV(COMPLEX(B5, C5), COMPLEX(D5, E5)) →**becomes**IMDIV(“1+2i”, “3+4i”) →**returns the quotient value**Output → 0.44+0.08i**

- Drag down the
**Fill Handle**tool.

Finally, we will get the following resultant values.

## How to Round Down a Complex Number in Excel

After using the** IMDIV** function the resultant values become so large after the decimal point, so we need to round down this value to clearly understand it. But the complex numbers can not be rounded down easily. So, we need to use a specialized formula for this purpose.

** Steps**:

- Type the following formula in cell
**E5**and press**ENTER**.

`=COMPLEX(VALUE(TEXT(IMREAL(D5), "0.000")), VALUE(TEXT(IMAGINARY(D5),"0.000")))`

__Formula Breakdown__

**IMREAL(D5) →**becomes**IMREAL(0.915094339622642+0.0471698113207547i) → The IMREAL function**returns the real part of the complex number.**Output → 0.915094339622642**

**TEXT(IMREAL(D5), “0.000”) →**becomes**TEXT(0.915094339622642, “0.000”) →****The TEXT function**will change the format of this number and round down it up to**3**decimal points.**Output → “0.915”**

**VALUE(TEXT(IMREAL(D5), “0.000”)) →**becomes**VALUE(“0.915”) →****The VALUE function**will convert the text into a number.**Output → 0.915**

**IMAGINARY(D5) →**becomes**IMAGINARY(0.915094339622642+0.0471698113207547i) → The IMAGINARY function**will return the imaginary part of the complex number**Output → 0.0471698113207547**

**TEXT(IMAGINARY(D5), “0.000”) →**becomes**TEXT(0.0471698113207547, “0.000”) → The TEXT function**will change the format of this number and round down it up to**3**decimal points.**Output → “0.047”**

**VALUE(“0.047”) → The VALUE function**will convert the text into a number.**Output → 0.047**

**COMPLEX(VALUE(TEXT(IMREAL(D5), “0.000”)), VALUE(TEXT(IMAGINARY(D5),”0.000″))) →**becomes**COMPLEX(0.915, 0.047) →**returns the complex number with a real number**915**and complex number**0.047**.**Output → 0.915+0.047i**

- Drag down the
**Fill Handle**tool.

** **

Finally, we have reduced the numbers after the points from the following complex numbers.

## Things to Remember

- You can not use
**2**imaginary number indicators;**i**, and**j**, for indicating two complex numbers inside**the IMDIV function**. If you combine these indicators for two complex numbers then the function will return**the #NUM! error**. - For indicating a complex number we have to use a lowercase
**i**or**j**, not uppercase**I**or**J**. - If you use any logical boolean value as an argument for the
**IMDIV**function then you will get**the #VALUE! error****.** - The final note is that you can not put
**0**as the second argument in the function.

## Practice Section

To practice by yourself, we have created a practice section on the right side of each sheet.

**Download Practice Workbook**

## Conclusion

In this article, we have discussed different ways to use the **IMDIV** function in Excel. Hope these methods will help you a lot. If you have any further queries, then leave a comment below.