The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj.
Convert coefficients to complex number
Complex number as text
=COMPLEX (real_num, i_num, [suffix])
real_num - The real number.
i_num - The imaginary number.
suffix - [optional] The suffix, either "i" or "j".
A complex number has two parts: a real number and an imaginary number. The COMPLEX function converts real and imaginary coefficients into a complex number of the form x + yi or x + yj, where x represents the real number and y represents the imaginary number. For example: