Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
Syntax
COMPLEX(real_num, i_num, [suffix])Argument
real_numobligatoriskt
The real coefficient of the complex number.
i_numobligatoriskt
The imaginary coefficient of the complex number.
suffixvalfritt
The suffix for the imaginary component, either 'i' or 'j'. Defaults to 'i'.
The COMPLEX function takes a real part and an imaginary part to construct a complex number string. You can optionally specify the suffix, which defaults to 'i' if omitted, or 'j' for engineering notation.
=COMPLEX(3, 4)→3+4iCreates a standard complex number with real part 3 and imaginary part 4.
=COMPLEX(2, -1, "j")→2-1jCreates a complex number using 'j' as the suffix for engineering notation.
Select a cell
Click on the cell where you want to display the complex number.
Enter the formula
Type =COMPLEX( followed by the real part, imaginary part, and optional suffix, then close with a parenthesis.
Yes, Excel treats the result as a text string, but many IM functions (like IMSUM or IMPRODUCT) can perform math on these strings.