COMPLEX:
Converts real and imaginary coefficients into a complex number
The COMPLEX function converts real and imaginary coefficients into a complex number.
COMPLEX takes
2 required arguments and
1 optional argument:
Syntax: COMPLEX(real_num,
i_num,
[suffix])
Using the COMPLEX function:
The arguments for the COMPLEX function are:
Argument

Required?

Description

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". 
• If real_num is nonnumeric, COMPLEX returns the #VALUE! error value. 
• If i_num is nonnumeric, COMPLEX returns the #VALUE! error value. 
• If suffix is neither "i" nor "j", COMPLEX returns the #VALUE! error value. 
The COMPLEX function converts real and imaginary coefficients into a complex number.