Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,180
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I graph a polar equation in Excel? felldiddy Charts and Charting in Excel 2 March 18th 07 11:43 PM
Is there a way to write an equation that ignores cells that have . UTmike Excel Worksheet Functions 2 April 4th 06 03:24 PM
How to write figures in words form? Amjad Excel Discussion (Misc queries) 3 August 29th 05 08:42 PM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? Daniel Excel Worksheet Functions 1 June 23rd 05 11:38 PM
How do I find an best fit equation in the form y=Ae^kx? Nadia Excel Worksheet Functions 1 February 13th 05 07:34 PM


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"