I. Intro

The IMDIV function is commonly used to divide one complex number by another. The two complex numbers are represented by x+yi and x+yj in this article.

II. Explanation

•Formula: =IMDIV(dividend,divisor)

•Parameters:

◦dividend (required): The complex number to be divided.

◦divisor (required): The complex number that divides the other.

•Example: = IMDIV("11+16i","3+2i")

•Note:

◦The mathematical formula used to divide complex numbers is shown in the figure below:

•You can use the IMDIV function to automatically calculate the result of this function in the sheet.

III. Steps

Use the IMDIV function

1.Select a cell and enter = IMDIV, or click Formulas on the toolbar. Select Engineering, then select the IMDIV function.

2.Enter formula parameters =IMDIV(A2,B2) into the cell.

3.Press Enter to display the result in the cell, which is 1.4+0.2i.

4.Drag + in the lower-right corner of the cell to apply the formula to other cells.

Delete the IMDIV function

Select the cell with the IMDIV function applied, and press Delete to clear the formula from the selected cell.