Thursday 18 October 2012

Imaginary number in Excel

I encounter a problem for calculation in Excel.

When I deal with imaginary number in Excel, I do not  know how to deal with imaginary number easily.

I have tried to convert imaginary number to pole coordinate .

Such as r(cosα+isinα),I can deal with it in Excel.

But it is very complicated.

I would like to know a better way to calculate imaginary in Excel.

2 comments:

  1. I have no knowledge about imaginary number in Excel.
    By the way, are you trying to calculate about fluid dynamics on EXCEL ? I heard it is very difficult.
    I especially have a interest to CFD. When you will meet me, please talk about it.

    ReplyDelete
  2. My problem is simple .

    I want to calculate the equation of three powers in Excel .

    a*x^3+b*x^2+c*x+d=0 x1= ? X2=? X3=?

    First I thought that it was easy, but it might be difficult .

    ReplyDelete