Using the Excel COMPLEX Function
SummaryThe Excel COMPLEX function converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
Syntax=COMPLEX (real_num, i_num, [suffix])
Syntax BreakdownReal Num
Required. Real coefficient of a complex number.
Required. Imaginary coefficient of a complex number.
Optional. Suffix for the imaginary component of the complex number, with options of either "i" or "j". If omitted, the argument is assumed to be "i".
The argument is case sensitive. Using "I" or "J" will result in the #VALUE! error being returned.
Usage NotesCOMPLEX converts real and imaginary coefficients into a complex number of the form x + yi or x + yj, where x represents the real number and y represents the imaginary number.
Complex numbers have two parts: the real number and the imaginary number.
The COMPLEX function returns the #VALUE! error in the following instances:
1) If real_num is non-numeric;
2) If i_num is non-numeric;
3) If suffix is neither "i" nor "j"