Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 3+4i
Creates a standard complex number with real part 3 and imaginary part 4.
=COMPLEX(2, -1, "j")Результат: 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.