# COMPLEX

Formulas / COMPLEX
Create complex numbers with real and imaginary coefficients.
`=COMPLEX(real_num, i_num, [suffix])`
• real_num - a real number
• i_num - a real number
• suffix - [OPTIONAL] the suffix for the imaginary component, either "i" or "j"

## Examples

• `COMPLEX(3,4)`

For example, this formula returns the complex number 3+4i.

• `COMPLEX(-2,3)`

The real number is the first argument of the COMPLEX function and the imaginary number is the second argument. For example, the formula above returns the complex number -2+3i.

• `COMPLEX(ABS(-2),SQRT(9))`

The COMPLEX function can also be used with other functions that return real numbers. For example, this formula returns the complex number 2+3i.

• `COMPLEX(3,0)`

The COMPLEX function can also be used to convert real numbers to complex numbers. For example, the above formula returns the complex number 3+0i, which is the same as 3.

## Summary

The COMPLEX function enables the conversion of real and imaginary coefficients into a complex number which is composed of x + yi or x + yj.

• The COMPLEX function returns a text result in the form of x + y or x + yj, representing a complex number.
• The function can convert real and imaginary coefficients into a complex number with either the suffix "i" or "j".

What is the COMPLEX function?
The COMPLEX function is a tool that converts real and imaginary coefficients into a complex number. A complex number is of the form x + yi or x + yj, where i and j represent the imaginary numbers.
What is the form of a COMPLEX number?
The form of a COMPLEX number is x + yi or x + yj, where i and j represent the imaginary numbers.
Are there any requirements for a COMPLEX number?
Yes, all suffixes must match when creating a COMPLEX number.
What are the benefits of using the COMPLEX function?
• The COMPLEX function simplifies the process of converting real and imaginary coefficients into a complex number.
• The COMPLEX function is more efficient than manually creating a complex number.
• The COMPLEX function can be used to quickly and accurately create complex numbers.

## Make Better Decisions With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.

Drop CSV