COMPLEX

Description Creates a complex number. The result is text in the form "a+bi" or "a+bj") where "a" and "b" are from the first two arguments.

Syntax COMPLEX ( real_number, imaginary_number [, suffix])

Argument Description

real_number Any number. The function returns this number as the real number "a" in the equation z = a + bi.

imaginary_ number Any number. The function returns this number as the imaginary number "b" in the equation z = a + bi.

[suffix] The letter respresenting the imaginary number. You may enter i or j. Uppercase versions of these characters will cause a #VALUE! error. If this argument is omitted, i is used.Any function that accepts two or more complex arguments must have the same suffix (i or j) on all arguments to that function, or a #VALUE error will result.

Argument	Description
real_number	Any number. The function returns this number as the real number "a" in the equation z = a + bi.
imaginary_ number	Any number. The function returns this number as the imaginary number "b" in the equation z = a + bi.
[suffix]	The letter respresenting the imaginary number. You may enter i or j. Uppercase versions of these characters will cause a #VALUE! error. If this argument is omitted, i is used.Any function that accepts two or more complex arguments must have the same suffix (i or j) on all arguments to that function, or a #VALUE error will result.

Examples This function returns 2+3i:

COMPLEX(2,3)

This function returns 2+3j:

COMPLEX(2,3,"j")