Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
COMPLEX(real_num, i_num, [suffix])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)Résultat : 3+4i
Creates a standard complex number with real part 3 and imaginary part 4.
=COMPLEX(2, -1, "j")Résultat : 2-1j
Creates a complex number using 'j' as the suffix for engineering notation.
Yes, Excel treats the result as a text string, but many IM functions (like IMSUM or IMPRODUCT) can perform math on these strings.