The COMPLEX function is used to convert real and imaginary coefficients into a complex number in the standard a + bi or a + bj format. This function is useful for creating complex numbers for use in mathematical calculations or engineering applications.


=COMPLEX(real_num, i_num, [suffix])

real_num The real coefficient of the complex number.
i_num The imaginary coefficient of the complex number.
suffix (Optional) The suffix to use for the imaginary unit. Defaults to "i" if omitted.


When working with complex numbers in Excel, the COMPLEX function proves to be a valuable ally. It allows you to easily create complex numbers using real and imaginary coefficients, providing a convenient way to represent and work with complex mathematical quantities within your Excel worksheets. This function is particularly useful in scientific, engineering, and mathematical applications where complex numbers play a crucial role in analysis and computations. By simply providing the real and imaginary components, you can swiftly generate complex numbers in the prescribed format, ready to be used in various calculations and simulations across different fields of study and application. With the optional suffix parameter, you have the flexibility to customize the imaginary unit as needed, catering to specific conventions or preferences in your work.


To create the complex number 3 + 4i, use the following formula: =COMPLEX(3, 4)

To create the complex number 5 + 2j, with the imaginary unit represented as 'j', use: =COMPLEX(5, 2, "j")


How can the COMPLEX function be used in engineering or scientific applications?

The COMPLEX function can be used to represent and work with complex quantities, such as electrical impedance in engineering or impedance in circuit analysis, where complex numbers are commonly employed to model and analyze system behavior and responses.

Can the suffix for the imaginary unit be customized?

Yes, the suffix for the imaginary unit can be customized by providing it as the optional suffix argument in the COMPLEX function. If omitted, the default suffix 'i' is used.

Is the COMPLEX function limited to specific fields or applications?

No, the COMPLEX function is versatile and can be used across various fields, including mathematics, engineering, physics, and other disciplines where complex numbers find utility in representing and analyzing dynamic and multidimensional systems and phenomena.

Related functions