COMPLEX

The COMPLEX function creates a complex number, given real and imaginary coefficients.

Sample Usage

COMPLEX(3, 4)

COMPLEX(3, -1, "j")

COMPLEX(3, 0)

Syntax

COMPLEX(real_part, imaginary_part, [suffix])

  • real_part - The real coefficient.
  • imaginary_part - The imaginary coefficient.
  • suffix - [ OPTIONAL "i" by default] The suffix for the imaginary coefficient.

See Also

  • IMREAL: Returns the real coefficient of a complex number.
  • IMAGINARY: Returns the imaginary coefficient of a complex number.

​Examples

1 A B
2 Formula Result
3 =COMPLEX(1, 2.5) 1+2.5i
4 =COMPLEX(0, 4, "j") 4j
5 =COMPLEX(3, -1) 3-i

 

Was this article helpful?
How can we improve it?