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"

Want to practice COMPLEX in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=COMPLEX(real_num, i_num, [suffix])

Arguments

ArgumentRequired?What it does
real_numYesThe real part.
i_numYesThe imaginary part.
suffixNo"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.

C2fx=COMPLEX(A2,B2)
ABC
1RealImaginaryComplex
2343+4i
33-13-i
4022i
5505
=COMPLEX(A2,B2) Explain

Example 2 — Impedance with the j suffix

A 40 Ω resistor in series with a coil of 30 Ω reactance.

C2fx=COMPLEX(A2,B2,"j")
ABC
1ResistanceReactanceImpedance
2403040+30j
3100-25100-25j
=COMPLEX(A2,B2,"j") Explain

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.
Kyle Stott

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.