Difference between revisions of "Manuals/calci/COMPLEX"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
*'S' should be either 'I' or 'j', otherwise it shows error value. | *'S' should be either 'I' or 'j', otherwise it shows error value. | ||
| − | |||
| − | + | ==Description== | |
| − | + | *COMPLEX(RN,IN,S) | |
| − | + | *=COMPLEX(5,2) is 5+2i | |
| − | + | *=COMPLEX(5,2,"j") is 5+2j | |
| − | + | Syntax | |
| − | + | Remarks | |
| − | + | ==Examples== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
Revision as of 22:50, 10 November 2013
COMPLEX(RN,IN,S)
- Where 'RN' is the real coefficient
- 'IN' is the imaginary coefficient of the complex number.
- 'S' is the suffix for the imaginary component of the complex number.
- 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.
Description
- 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 |
