COMPLEX function
Summary
Converts real and imaginary coefficients into a complex number
Syntax
COMPLEX(real_num, i_num, [suffix])
The COMPLEX function syntax has the following arguments:
• Real_num Required. The real coefficient of the complex number.
• I_num Required. The imaginary coefficient of the complex number.
• Suffix Optional. The suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be "i".
Note: All complex number functions accept "i" and "j" for suffix, but neither "I" nor "J". Using uppercase results in the #VALUE! error value. All functions that accept two or more complex numbers require that all suffixes match.
• Real_num Required. The real coefficient of the complex number.
• I_num Required. The imaginary coefficient of the complex number.
• Suffix Optional. The suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be "i".
Note: All complex number functions accept "i" and "j" for suffix, but neither "I" nor "J". Using uppercase results in the #VALUE! error value. All functions that accept two or more complex numbers require that all suffixes match.
Example
=COMPLEX(3,4)
=COMPLEX(3,4,"j")
=COMPLEX(0,1)
=COMPLEX(1,0)
=COMPLEX(3,4,"j")
=COMPLEX(0,1)
=COMPLEX(1,0)