COMPLEX

  • Updated

Creates a complex number given real and imaginary coefficients.

Sample Usage

COMPLEX(1,3,"j")
COMPLEX(0,1)

Syntax

COMPLEX(number1, number2, [suffix])

  • number1 - The real coefficient.
  • number2 - The imaginary coefficient.
  • suffix - [OPTIONAL] The suffix for the imaginary coefficient.

Examples

COMPLEX(1,3,"j") returns a value of 1+3j.
COMPLEX(0,1) returns a result of 'i'.

Notes

  • If number1 is nonnumeric, COMPLEX returns an error.
  • If number2 is nonnumeric, COMPLEX returns an error.
  • suffix must be enclosed in double quotes.
  • suffix is i by default. 
  • suffix must be i or j, and must be lowercase.