COMPLEX
Syntax:
COMPLEX ( real-number , imaginary-number [ , suffix ] )
Description: Makes a complex number in x + yi or x + yj text format from the arguments.
Arguments:
Name |
Type |
Description |
---|---|---|
real-number |
number |
The real number coefficient. |
imaginary-number |
number |
The imaginary number coefficient. |
suffix |
text |
" |
Return Type and Value: text – The complex number string specified by the arguments.
If real-number has the value 0 and imaginary-number has a non-zero value, the resulting string contains just the real number. If real-number has a non-zero value and imaginary-number has a zero value, the resulting string contains just the imaginary number and suffix. If both real-number and imaginary-number have a zero value, the resulting string is "0"
.
However, if suffix is neither "i
" nor "j
", #VALUE!
is returned.