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

## Download Practice Workbook

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

## 3 Examples of IMDIV Function in Excel

In the following examples, we demonstrated the usage of **the IMDIV function **in Excel. For creating this article, we have used ** 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")`

**Read More: ****How to Use IMPRODUCT Function in Excel (4 Examples)**

__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***Read More: ****How to Add Complex Numbers in Excel (With Easy Steps)**

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

**Read More: ****How to Use COMPLEX Function in Excel (2 Practical Examples)**

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

**Read More: ****How to Convert Complex Numbers to Polar Form in Excel**

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

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