Thursday 13 December 2012

Imaginery number calculation in Excel

I could find excel functions for the calculation of imaginery number on web.

Therefore my problem about the calculation was solved.

Those functions of complex, imsum, improduct,imsub,imdiv, imreal and imaginery are so useful.

I do not have to worry about the negative number in root .

5 comments:

  1. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
  2. Is your job Computational Fluid Dynamics ? It seems difficult theme.
    I can understand by knowledge that the imaginary number is important for many calculation. But, I can't understand by my actual feeling that the imaginary number is applied for real event. Because "imaginary" means "not real".

    ReplyDelete
  3. I used the complex number to solve a cubic equation.

    If the imaginery number of the complex number is very small,

    the complex number can be regarded as a real number.

    Of course, that is not correct actually.

    But it was enough for my approximate calculation.

    ReplyDelete