Excel Function : COMPLEX
Converts real and imaginary coefficients into a complex number
Microsoft Excel Reference Page
Syntax and Description of the COMPLEX Excel Function
The syntax for the COMPLEX function in Microsoft Excel is: COMPLEX( real_num, imaginary_num, [suffix] ) real_num is the real part of the complex number. imaginary_num is the imaginary part of the complex number. suffix is an optional argument that specifies the suffix for the imaginary part of the complex number. The suffix can be "i" or "j". If omitted, the suffix will default to "i".
About COMPLEX Excel Function
The COMPLEX function in Excel converts a real number to a complex number of the form x + yi. The real part of the complex number is x and the imaginary part is y.