From ZCubes Wiki
Revision as of 04:49, 17 April 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''MAKECOMPLEXIMINUS(real,imaginary,suffix)'''</div><br/> *<math>real</math> is the real part of the complex number. *<math>imaginary</math> is th...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

  • is the real part of the complex number.
  • is the imaginary part of the complex number.
  • is the imaginary unit of the complex number.


  • MAKECOMPLEXIMINUS function converts the imaginary coefficient of a complex number into 'negative' coefficient.
  • 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. . Because a negative times a negative is positive.
  • A complex number is in the form , where and are real numbers and is the imaginary unit. Where
  • To mention and , we must use the lower case only
  • In a complex number real part is denoted by & imaginary part is denoted by .
  • MAKECOMPLEXIMINUS returns the error value, when and are non-numeric.
  • should be either or , 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.
  1. =MAKECOMPLEXIMINUS (5,2) gives
  2. =MAKECOMPLEXIMINUS (5,2,["j"]) gives


  • The syntax is to calculate MAKECOMPLEXIMINUS in ZOS is

  • is the real part.
  • is the imaginary part.
  • is imaginary unit which is either "i" or "j".


  1. =MAKECOMPLEXIMINUS(4,5) = 4-i5
  2. =MAKECOMPLEXIMINUS(4,-5) = 4+i5
  3. =MAKECOMPLEXIMINUS(1,10,"j") = 1-j10
  4. =MAKECOMPLEXIMINUS(1,0) = 1+i0
  5. =MAKECOMPLEXIMINUS(1..3,5) = 1-i5 ; 2-i5; 3-i5

Related Videos

Complex Numbers

See Also


Complex Numbers