Changes

==Description==

==Description==

*COMPLEX function converts the real and imaginary coefficients into a complex number.

*COMPLEX function converts the real and imaginary coefficients into a complex number.

*A complex number is a number is  in the form <math> z = a + bi</math>, where a and b are real numbers and <math>i</math> is the imaginary unit and <math>i=\sqrt{-1}</math>

*A complex number is a number is  in the form <math> z = a + bi</math>, where a and b are real numbers and <math>i</math> is the imaginary unit. Where <math>i=\sqrt{-1}</math>

*In COMPLEX(RN,IN,SF), here RN is the real part of a complex number,IN is the imaginary part of a complex number and SF is the imaginary unit of a complex number like <math>i</math> or <math>j</math>.

*In <math>COMPLEX(RN,IN,SF)</math>, here RN is the real part of a complex number,IN is the imaginary part of a complex number and SF is the imaginary unit of a complex number like <math>i</math> or <math>j</math>.

*To mention <math>i</math> and <math>j</math> we must use the lower case only

*To mention <math>i</math> and <math>j</math>, we must use the lower case only

*In a complex number <math>z</math> real part is denoted by <math>Re(z)</math> & imaginary part is denoted by <math>Im(z)</math>.

*In a complex number <math>z</math> real part is denoted by <math>Re(z)</math> & imaginary part is denoted by <math>Im(z)</math>.

*COMPLEX returns the error value, when RN and IN are non-numeric.

*COMPLEX returns the error value, when RN and IN are non-numeric.

*Suffix 'S' should be either <math>i</math> or <math>j</math>, otherwise it shows error value.

*Suffix 'S' should be either <math>i</math> or <math>j</math>, otherwise it shows error value.

*A Complex number whose real part is zero is said to be purely imaginary.

*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.  

*A Complex number whose imaginary part is zero is a real number. In that cases we have to assign '0' for that part.  

 

**<math>=COMPLEX(5,2)</math> gives <math>5+2i</math>

*<math>=COMPLEX(5,2)</math> gives <math>5+2i</math>

**<math>=COMPLEX(5,2,"j")</math> gives <math>5+2j</math>

*<math>=COMPLEX(5,2,"j")</math> gives <math>5+2j</math>

==Examples==

==Examples==