Excel Function : COMPLEX

Download now!

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.