IMDIV Function

All versions Engineering

The Excel IMDIV function divides one complex number by another — part of Excel’s complex-number toolkit for engineering and signal analysis.

Quick answer:

=IMDIV("3+4i","1+2i") // 2.2-0.4i

Syntax

=IMDIV(inumber1, inumber2)

Argument		Description
`inumber1`	Required	The numerator.
`inumber2`	Required	The denominator.

How to use it

IMDIV divides one complex number by another. Complex numbers are written as text like "3+4i" (or with a "j" suffix). Build them with COMPLEX and pull the parts back out with IMREAL and IMAGINARY.

=IMDIV("3+4i","1+2i") // 2.2-0.4i

All IM functions take and return text. Keep complex numbers as text strings throughout your calculation chain; use IMREAL / IMAGINARY only when you need numeric parts for charts or further math.

Try it: interactive demo

Live demo

Enter a complex number (a+bi) and see the formula IMDIV would evaluate.

inumber

Practice workbook

📊

Download the free IMDIV practice workbook

Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.

Frequently asked questions

How are complex numbers stored in Excel?

As text strings like "3+4i" or "3+4j". Build them with COMPLEX and read parts with IMREAL/IMAGINARY.

Does IMDIV return text or a number?

Text — a complex number string you can feed into other IM functions.

Can I mix i and j suffixes?

No — all complex numbers in one calculation must use the same suffix. COMPLEX lets you choose which.

What if my real or imaginary part is zero?

Excel simplifies the display: COMPLEX(3,0) returns "3" and COMPLEX(0,4) returns "4i".

Master functions like this in one day

This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related functions: COMPLEX · IMREAL · IMAGINARY · IMABS · IMSUM