IMDIV function
IMDIV divides one complex number by another and returns the quotient as text. A complex number is one written in x+yi form, and dividing by 0 gives a #NUM! error.
Example
Read it as a sentence: divide the complex number in D1 (which is empty, so counted as 0) by 1.
Excel shows 0
D
1
Data
Syntax
IMDIV(inumber1, inumber2)
-
inumber1(required) - The complex numerator.
-
inumber2(required) - The complex divisor.
Returns: The quotient as text.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=IMDIV("3+4i","1-2i") | -1+2i | (3+4i)/(1-2i) |
=IMDIV(6,3) | 2 | Numbers |
=IMDIV(Data!D1,1) | 0 | Blank |
=IMDIV("3+4i",0) | #NUM! | Divide by 0 |
=IMDIV("1","0i") | #NUM! | Divide by "0i" |
=IMDIV("3+4i","1-2j") | #NUM! | Mixed suffix i and j |
=IMDIV("abc",1) | #NUM! | Invalid |
=IMDIV(Data!W1:W2,"i") | #VALUE! | Spill |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
W
1
3+4i
2
1-2i
Data
Watch out for
- Dividing by 0 gives #NUM!.
- Result is text.
Where it works
- Excel
- IMDIV is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .