COMPLEX Function in Google Sheets

Create a complex number using the COMPLEX function.

COMPLEX Function

The COMPLEX function in Google Sheets is used to create a complex number from given real and imaginary parts.

Syntax

COMPLEX(real_part, imaginary_part, [suffix])
  • real_part: The real part of the complex number. This is a required parameter.
  • imaginary_part: The imaginary part of the complex number. This is a required

parameter.

  • suffix: (Optional) The suffix for the imaginary part. Default is "i".

Examples

  1. Basic Example

Create a complex number with real part 3 and imaginary part 4:

=COMPLEX(3, 4)

This will output 3+4i.

  1. Using a Different Suffix

Create a complex number with real part 5 and imaginary part 2, using the suffix "j":

=COMPLEX(5, 2, "j")

This will output 5+2j.

Notes

  • The function is useful for performing calculations with complex numbers.
  • If suffix is omitted, the default "i" is used.
  • IMAGINARY: Extract the imaginary part of a complex number.
  • REAL: Extract the real part of a complex number.