# How to Use IMDIV Function in Excel (3 Examples)

Get FREE Advanced Excel Exercises with Solutions!

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. ## 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. ## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  