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".

Frequently Asked Questions

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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV