Thread: Polar to rectangular coordinate conversion
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tushar Mehta[_3_] 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 QuoteReply With Quote