COMPLEX Function
Builds a complex number from its real and imaginary parts.
Category
Engineering
Available in
All versions, Microsoft 365
Returns
Complex number text, like "3+4i"
Overview
A complex number has a real part and an imaginary part — written 3+4i, where i is the square root of −1. Electrical engineers use them for AC circuits and write j instead of i.
COMPLEX joins two numbers into the text form every IM… function understands. Parts equal to 1 or 0 are tidied: COMPLEX(3,1) is "3+i" and COMPLEX(5,0) is "5".
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| real_num | Yes | The real part. |
| i_num | Yes | The imaginary part. |
| suffix | No | "i" (the default) or "j" — lower case only. |
Examples
Example 1 — Real + imaginary → complex
Column A holds the real part and column B the imaginary part.
| A | B | C | |
|---|---|---|---|
| 1 | Real | Imaginary | Complex |
| 2 | 3 | 4 | 3+4i |
| 3 | 3 | -1 | 3-i |
| 4 | 0 | 2 | 2i |
| 5 | 5 | 0 | 5 |
Example 2 — Impedance with the j suffix
A 40 Ω resistor in series with a coil of 30 Ω reactance.
| A | B | C | |
|---|---|---|---|
| 1 | Resistance | Reactance | Impedance |
| 2 | 40 | 30 | 40+30j |
| 3 | 100 | -25 | 100-25j |
Common mistakes
- #VALUE! The suffix is anything other than "i", "j" or empty — even a capital "I" or "J".
- Mixing i and j. IMSUM("1+2i","3j") returns #VALUE!. Keep one suffix throughout a workbook.
Notes
- Typing the text directly ("3+4i") works just as well; COMPLEX is handy when the parts come from other cells.
- Related functions: IMREAL, IMAGINARY, IMABS, IMSUM.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.