IMDIVFunction in Excel returns the quotient on division of two complex numbers. (i.e. divides one complex number from another)
Syntax: =IMDIV ( inumber1 , inumber2 )
The IMDIV function syntax has the following arguments:
- Inumber1 Required. The complex numerator or dividend.
-
Inumber2 Required. The complex denominator or divisor.
Example: Let’s look at some Excel IMDIV function examples and explore how to use the IMDIV function as a worksheet function in Microsoft Excel:
Syntax: =IMDIV(A2,B2)
Result:
Based on the Excel spreadsheet above, the following IMDIV examples would return:
Syntax: =IMDIV(A3,B3)
Result: 1.2+0.4i
Syntax: =IMDIV(A4,B4)
Result: 1.5+0.5i
Syntax: =IMDIV(A5,B5)
Result: 1
Syntax: =IMDIV(A6,B6)
Result: 1
Syntax: =IMDIV(A7,B7)
Result: 24i
Syntax: =IMDIV(A8,B8)
Result: 1.5+0.5i
Syntax: =IMDIV(A9,B9)
Result: -0.538461538461539+1.69230769230769i
Syntax: =IMDIV(A10,B10)
Result: 0.275862068965517-2.31034482758621i
Syntax: =IMDIV(A11,B11)
Result: -0.692307692307692-3.53846153846154i
Syntax: =IMDIV(A12,B12)
Result: 6.16216216216216-4.97297297297297j
Syntax: =IMDIV(A13,B13)
Result: 12.0414201183432-4.89940828402367i
Note:
- Use COMPLEX to convert real and imaginary coefficients into a complex number.
-
The quotient of two complex numbers is:
