Polar to rectangular coordinate conversion

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

 

[Guest]

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

 

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

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.