May 9, 2021
IMDIV Function - How to use IMDIV Function in Excel

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 IMSUB Function in Excel

Leave a Reply

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