Excel Function : COMPLEX
Category
Engineering
Description
Converts real and imaginary coefficients into a complex number
Microsoft Excel Reference Page
https://support.office.com/en-us/article/COMPLEX-function-f0b8f3a9-51cc-4d6d-86fb-3a9362fa4128
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.