Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how can i write an equation in polar form in excel

3,564 views
Skip to first unread message

vi_friend

unread,
Jan 13, 2008, 2:54:01 PM1/13/08
to
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.

David Biddulph

unread,
Jan 13, 2008, 3:46:18 PM1/13/08
to
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?
--
David Biddulph

"vi_friend" <vi_f...@discussions.microsoft.com> wrote in message
news:F6B62EA9-4CE2-4A92...@microsoft.com...

Bernard Liengme

unread,
Jan 13, 2008, 4:08:14 PM1/13/08
to
Some stuff here might help:
http://people.stfx.ca/bliengme/ExcelTips/Polar.htm
If no, please give us more details
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"vi_friend" <vi_f...@discussions.microsoft.com> wrote in message
news:F6B62EA9-4CE2-4A92...@microsoft.com...

Herbert Seidenberg

unread,
Jan 14, 2008, 9:49:19 AM1/14/08
to
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


0 new messages