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.