View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default How to determine the x & y coordinates based on angles for circle?

Just another option: However, the engineering funtions make this a little
hard to do with Excel. Don't forget to convert Degrees to Radians. Radius
here is 1.

[x] =IMREAL(IMEXP(COMPLEX(LN(1),RADIANS(A1))))

[y] =(IMAGINARY(IMEXP(COMPLEX(LN(1),RADIANS(A1)))))

--
HTH :)
Dana DeLouis
Windows XP & Excel 2007


"Eric" wrote in message
...
Does anyone know any excel function on how to determine the x & y
coordinates
based on angles for circle?
For example, the radius of circle is 1,
if the angle is 0 degree, the the coordinate is (1,0),
if the angle is 90 degree, the the coordinate is (0,1),
if the angle is 60 degree, does anyone have any suggestion on how to
determine the coordinate?
Thank for any suggestions
Eric