In this article
IMDIV divides one complex number by another, e.g. current = voltage / impedance.
Advertisement
Syntax
=IMDIV(inumber1, inumber2)| Argument | What it means |
|---|---|
inumber… |
Complex numbers as text |
Examples
Example 1
=IMDIV(A2,"1-i")Result: -0.5+3.5i. See the worked example table below for more cases.
IMDIV in practice
Where you will use it
- Series and parallel impedance
- Ohm's law with phasors
- Coursework
Worked example
| z | Formula | Result |
|---|---|---|
| 3+4i | =IMDIV(A2,"1-i") | -0.5+3.5i |
| 1-i | =IMDIV(A3,"1-i") | 1 |
| 2i | =IMDIV(A4,"1-i") | -1+i |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Number instead of text | Plain numbers work as real values, but complex ones must be text |
| Division by 0 | #NUM! |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong