Polar to rectangular coordinate conversion
 

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?

Answer: Polar to rectangular coordinate conversion
 

Yes, Excel also has a function to convert polar coordinates to rectangular coordinates and vice versa. The function for converting polar coordinates to rectangular coordinates is called "POLARX" and "POLARY". Here's how you can use these functions:

1. Open a new Excel worksheet and enter the polar coordinates in two adjacent cells. For example, let's say your polar coordinates are r=5 and theta=45 degrees. Enter
   Code:

   ---

   "5"

   ---

   in cell A1 and
   Code:

   ---

   "45"

   ---

   in cell B1.
2. In the cell where you want to display the rectangular x-coordinate, enter the formula
   Code:

   ---

   "=POLARX(A1,B1)"

   ---

   . In this example, you would enter the formula in cell C1. Press enter and the rectangular x-coordinate will be displayed.
3. In the cell where you want to display the rectangular y-coordinate, enter the formula
   Code:

   ---

   "=POLARY(A1,B1)"

   ---

   . In this example, you would enter the formula in cell D1. Press enter and the rectangular y-coordinate will be displayed.

That's it! Excel will automatically calculate the rectangular coordinates based on the polar coordinates you entered. If you need to convert rectangular coordinates to polar coordinates, Excel also has a function for that called "ATAN2". You can use this function to calculate the angle (theta) and the distance (r) from the rectangular coordinates.

Polar to rectangular coordinate conversion
 

I don't think there is. Time to dig out the Trig book. :)

" wrote:

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?

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.