Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
COMPLEX
Builds a complex number from real and imaginary coefficients.
Rarely usedDifficulty 1400 · AdvancedUsage rank #466 of 520
When to use it
Builds a complex number as text from real and imaginary parts, with i or j as the suffix.
The shape of it
- Syntax
=COMPLEX(real_num, i_num, [suffix])
Worked examples
Simple
=COMPLEX(3,4) → 3+4i
Standard form.
j suffix
=COMPLEX(3,4,"j") → 3+4j
Engineering suffix.
Pure imaginary
=COMPLEX(0,1) → i
A pure imaginary unit.
Worth knowing
- Always build complex numbers this way so the text format is valid for the IM functions.
- Suffix must be lowercase i or j.
- A zero imaginary part gives a plain number as text.
Where it goes wrong
- #VALUE! for a suffix other than "i" or "j".
- Uppercase I or J is rejected.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.