Polar to rectangular coordinate conversion

M

mahadevan.swamy

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?
 
T

Tushar Mehta

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?
Click to expand...
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.
 
Top