Changes

<div style="font-size:30px">'''COMPLEX(RN,IN,SF)'''</div><br/>

<div style="font-size:30px">'''COMPLEX(rn,in,sf)'''</div><br/>

*'RN' is the real number.

*<math>rn</math> is the real number.

*'IN' is the imaginary number.

*<math>in</math> is the imaginary number.

*'SF' is the suffix for the imaginary number.

*<math>sf</math> is the suffix for the imaginary number.

==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. Where <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 <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>.

*In <math>COMPLEX(rn,in,sf)</math>, here <math>rn</math> is the real part of a complex number,<math>in</math> is the imaginary part of a complex number and <math>sf</math> 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 <math>rn</math> and <math>in</math> are non-numeric.

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

*Suffix <math>sf</math> 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.  

{| id="TABLE3" class="SpreadSheet blue"

{| id="TABLE3" class="SpreadSheet blue"

|- class="even"

|- class="even"

| Complex(RN,IN,SF)

| Complex(rn,in,sf)

! RN

! rn

! IN

! in

! SF

! sf

! RESULT

! RESULT

|-

|-