Manuals/calci/COMPLEX

COMPLEX (Real,Imaginary,Suffix)

$Real$ is the real part of the complex number.
$Imaginary$ is the imaginary part of the complex number.
is the imaginary unit of the complex number.
- COMPLEX(), converts real and imaginary coefficients into a complex number.

Description

COMPLEX function converts the real and imaginary coefficients into a complex number.
A complex number is a combination of a real and an imaginary number.
A number which is positive or negative, rational or irrational or decimals are called real numbers.
An Imaginary number is a number that when squring it gives a negative result.
For e.g. ${-4}^{2}=16$ . Because a negative times a negative is positive.
A complex number is a number is in the form $z=a+bi$ , where $a$ and $b$ are real numbers and $i$ is the imaginary unit. Where $i={\sqrt {-1}}$
In $COMPLEX(Real,Imaginary,Suffix)$ , here $Real$ is the real part of the complex number, $Imaginary$ is the imaginary part of the complex number and $Suffix$ is the imaginary unit of a complex number like $i$ or $j$ .
To mention $i$ and $j$ , we must use the lower case only
In a complex number $z$ real part is denoted by $Re(z)$ & imaginary part is denoted by $Im(z)$ .
COMPLEX returns the error value, when $Real$ and $Imaginary$ are non-numeric.
$Suffix$ should be either $i$ or $j$ , otherwise it shows error value.
A Complex number whose real part is zero is said to be purely imaginary.
A Complex number whose imaginary part is zero is a real number. In that cases we have to assign '0' for that part.
- COMPLEX(5,2) gives $5+2i$
- COMPLEX(5,2,"j") gives $5+2j$

Complex Number

Spreadsheet
COMPLEX(real,imaginary,suffix)	rn	in	sf	RESULT
COMPLEX(5,6)	5	6		5+6i
COMPLEX(5,2,"j")	5	2	j	5+2j
COMPLEX(2,0,"i")	2	0	i	2+0i
COMPLEX(0,-4,"i")	0	-4	i	0 + -4i
COMPLEX(5,"j")	5		j	#N/A (INVALID IMAGINARY COEFFICIENTS)