Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
이 함수는 Google Sheets에서도 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.