What is the syntax for IMDIV in Excel?

The syntax for IMDIV is: =IMDIV(inumber1, inumber2)

How do I use the IMDIV function?

To use IMDIV, type =IMDIV( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

Why is IMDIV not working in my Excel?

Common issues with IMDIV include #NUM! if dividing by zero. Start by checking the syntax =IMDIV(inumber1, inumber2), then verify each referenced cell or range.

Engineering

IMDIV Function in Excel

Returns the quotient of two complex numbers.

Syntax

=IMDIV(inumber1, inumber2)

Arguments

inumber1 (required): Complex numerator
inumber2 (required): Complex denominator

Examples

=IMDIV("5+10i", "3+4i") - Divide complex numbers - Result: 2.2+0.4i

IMDIV in technical sheets

Document units in adjacent cells — many engineering functions require exact unit strings.
Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

#NUM! if dividing by zero

Use cases

Complex division
Engineering
Mathematics

Frequently asked questions

What is the IMDIV function in Excel? IMDIV returns the quotient of two complex numbers. The syntax is =IMDIV(inumber1, inumber2). Typical use cases include complex division, engineering, mathematics.
How do I use the IMDIV function? To use IMDIV, type =IMDIV( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
Why is IMDIV not working in my Excel? Common issues with IMDIV include #NUM! if dividing by zero. Start by checking the syntax =IMDIV(inumber1, inumber2), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.