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. About the function
- Formula: =IMDIV(dividend,divisor)
- Arguments:
- dividend (required): The complex number to be divided.
- divisor (required): The complex number that divides the other.
Note:
- The COMPLEX function can be used convert real and imaginary coefficients into a complex number.
- The quotient of two complex numbers is shown below. The IMDIV function can be used to calculate the result.
250px|700px|reset
III. Steps
Use the function
- Select a cell and enter = IMDIV, or click Formulas on the toolbar. Select Engineering, then select IMDIV.
- Enter the arguments =IMDIV(A2,B2) into the cell.
- Press Enter to get the result, which is 1.4+0.2i.
250px|700px|reset
Delete the function
Select the cell with the IMDIV function and press Delete.