Changes

*<math>real</math> is the real part of the complex number.

*<math>real</math> is the real part of the complex number.

*<math>imaginary</math> is the imaginary part of the complex number.

*<math>imaginary</math> is the imaginary part of the complex number.

*<math>suffixf</math> is the imaginary unit of the complex number.

*<math>suffix</math> is the imaginary unit of the complex number.

==Description==

==Description==

*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 <math>rn</math> and <math>in</math> are non-numeric.

*COMPLEX returns the error value, when <math>real</math> and <math>imaginary</math> are non-numeric.

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

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

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

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

|- class="even"

|- class="even"

| Complex(rn,in,sf)

| Complex(real,imaginary,suffix)

! rn

! rn

! in

! in