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:

IMDIV Function in Excel 2 - How to use IMDIV Function in Excel

Syntax:  =IMDIV(A2,B2)

Result:

IMDIV Function - How to use IMDIV Function in Excel

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: IMDIV Function in Excel - How to use IMDIV Function in Excel

READ:  How to use HEX2BIN Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *