ExcelFlux

IMDIV function

the quotient of two complex numbers.

Engineering · Guided Excel example

Where can you use it?

Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.

Scenario in the workbook

Divide complex quantities. The denominator must be nonzero; equal values give one.

A worked example from the workbook

RowAB
6InputSecond input
72+2i1+i
8ii
96+3i3
Record 1
=IMDIV(A7,B7)

Illustrative output2

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=IMDIV("2+2i","1+i")
Turkish Excel · tr-TR
=SANBÖL("2+2i";"1+i")

Expected result

“2”

Worked examples

Divide complex quantities. The denominator must be nonzero; equal values give one.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B
6 Input Second input
7 2+2i 1+i
8 i i
9 6+3i 3
Trial Expression Sample output
Record 1 =IMDIV(A7,B7) 2
Record 2 =IMDIV(A8,B8) 1
Record 3 =IMDIV(A9,B9) 2+i
Microsoft Excel reference