how can i write an equation in polar form in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vi_friend - 13 Jan 2008 19:54 GMT

i need to use excel in some calculatoin and i found difficult to write an
equation in polar as polar contain angle, so there is no way to write a polar
if there is no angle.

Reply to this Message

David Biddulph - 13 Jan 2008 20:46 GMT

You are right. If you don't have an angle, you can't write the equation in
polar form.
You may, of course, have parameters from which you can derive an angle.
What is it that you are trying to calculate? Why the particular desire to
do it in polar form?

Signature

David Biddulph

>i need to use excel in some calculatoin and i found difficult to write an
> equation in polar as polar contain angle, so there is no way to write a
> polar
> if there is no angle.

Reply to this Message

Bernard Liengme - 13 Jan 2008 21:08 GMT

Some stuff here might help:
http://people.stfx.ca/bliengme/ExcelTips/Polar.htm
If no, please give us more details
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>i need to use excel in some calculatoin and i found difficult to write an
> equation in polar as polar contain angle, so there is no way to write a
> polar
> if there is no angle.

Reply to this Message

Herbert Seidenberg - 14 Jan 2008 14:49 GMT

You could do your math with complex numbers.
To convert polar to complex, use
=IMEXP(COMPLEX(LN(rho),theta))
Kudos to Dana DeLouis 8/28/2006

Reply to this Message