COMPLEX Function in Excel: Syntax, Examples and Free Practice
COMPLEX is an Excel Engineering function. Combines real and imaginary parts into a complex number.
COMPLEX syntax
Arguments
real_num: The real coefficient of the complex numberi_num: The imaginary coefficient of the complex numbersuffix: The label used for the imaginary unit ("i" or "j") (optional)
When to use COMPLEX
A specialized function used in scientific and engineering calculations rather than typical day-to-day business reporting.
Practice COMPLEX online, free
Open the live Excel-style spreadsheet and try COMPLEX yourself. No Excel install or sign-up needed to start.
Practice COMPLEX now →More Engineering functions
Frequently asked questions
What does the COMPLEX function do in Excel?
Combines real and imaginary parts into a complex number.
What is the syntax of COMPLEX in Excel?
The syntax is =COMPLEX(real_num, i_num, [suffix]). real_num: The real coefficient of the complex number; i_num: The imaginary coefficient of the complex number; suffix: The label used for the imaginary unit ("i" or "j") (optional).
Where can I practice COMPLEX online for free?
Open the free live spreadsheet on Cellgrids and try COMPLEX yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Engineering functions · Excel case studies · Excel tutorials · Excel shortcuts