IMDIV

Excel Functions

Get quotient of two complex numbers.

Syntax

EXCEL

=IMDIV(complex_num1, complex_num2)

Arguments

Parameter	Description
`complex_num1`	The first complex number.
`complex_num2`	The second complex number.

Return Value

The result of dividing two complex numbers.

Details

The Excel IMDIV function returns the quotient of two complex numbers. For example, given "-7+11i" and "3+5i" as input, the function returns the quotient "1+2i", which is the result of dividing the first number by the second. The quotient of two complex numbers can be visualized by uniformly stretching and rotating the coordinate system so that "1" goes to the complex number, which is the divisor. In this case, the transformed coordinate system (shown in blue) is stretched and rotated so that "1" (shown as the green arrow) goes to the point "3+5i". The quotient represents how to get to the first complex number, "-7 +11i", in terms of the transformed coordinates. Here's another example: the result of dividing "-14-2i" by "4+2i" is equal to "-3+i". If we uniformly stretch and rotate the coord

Examples

Example 1

The Excel IMDIV function returns the quotient of two complex numbers. For example, given "-7+11i" and "3+5i" as input, the function returns the quotie

EXCEL

=IMDIV(COMPLEX(-7,11),COMPLEX(3,5)) // returns 1+2i

Example 2

Here's another example: the result of dividing "-14-2i" by "4+2i" is equal to "-3+i".

EXCEL

=IMDIV(COMPLEX(-14,-2),COMPLEX(4,2)) // returns -3+i

Example 3

We can visualize the example that corresponds to this one by switching the divisor with the quotient. In other words, the result of dividing "-14-2i"

EXCEL

=IMDIV(COMPLEX(-14,-2),COMPLEX(-3,1)) // returns 4+2i

IMDIV

Syntax

Arguments

Return Value

Details

Examples

See Also