COMPLEX(RN,IN,S)
- 'RN' is the real number.
- 'IN' is the imaginary number.
- 'S' is the suffix for the imaginary number.
Description
- COMPLEX function converts the real and imaginary coefficients into a complex number.
- COMPLEX returns the error value, when RN and IN are non-numeric.
- 'S' should be either 'I' or 'j', otherwise it shows error value.
- COMPLEX(RN,IN,S)
- =COMPLEX(5,2) is 5+2i
- =COMPLEX(5,2,"j") is 5+2j
Syntax Remarks
Examples
Column1 | Column2 | Column3 | Column4 | |
Row1 | 5 | 2 | 5+2i | 5+2j |
Row2 | ||||
Row3 | ||||
Row4 | ||||
Row5 | ||||
Row6 |