Menu

Polar to rectangular coordinate conversion

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.misc

Tushar Mehta[_3_] Tushar Mehta[_3_] is offline

Tushar Mehta[_3_] is offline

external usenet poster

Posts: 37

Default

Polar to rectangular coordinate conversion

In article .com,
says...
In my calculator, I have a function to convert rectangular to polar
and vice versa. I input r and thetha coordinate in my calculator and
it gives me x and y. Is there something like this in excel?

Nothing built-in but the formulae are straightforward. Given x, y, and
r, theta, convert with

x= r * cos (theta)
y= r * sin (theta)

r= sqrt(x^2+y^2)
theta = tan-inverse (y/x); adjust for the quadrant in which the (x,y)
point lies.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Help! Find Closest Coordinate Match	Bill	Excel Discussion (Misc queries)	6	May 2nd 23 07:42 PM
Labeled Coordinate Plots	Stroma36	Excel Discussion (Misc queries)	2	March 14th 07 03:31 PM
how to make the rectangular cursor box in blinking mode?	artig	Excel Discussion (Misc queries)	1	June 25th 06 06:00 PM
Can I change legend keys to rectangular instead of square in exce.	BlondRapunzil	Charts and Charting in Excel	2	March 17th 05 10:05 AM
Creating an x,y coordinate chart	smintey	Charts and Charting in Excel	2	December 9th 04 04:01 PM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement