May 9, 2021

# How to use IMDIV Function in Excel

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:

READ:  How to use IMSUB Function in Excel

#### Excel

View all posts by Excel →