ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how can i write an equation in polar form in excel (https://www.excelbanter.com/excel-worksheet-functions/172856-how-can-i-write-equation-polar-form-excel.html)

vi_friend

how can i write an equation in polar form in excel
 
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[_2_]

how can i write an equation in polar form in excel
 
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" wrote in message
...
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.




Bernard Liengme

how can i write an equation in polar form in excel
 
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" wrote in message
...
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.




Herbert Seidenberg

how can i write an equation in polar form in excel
 
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




All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com