Hi, Sorry I missed the already tried portion of your post.
To convert from polar to rectangular coordinates, say you have in polar (r, theta)
Then in rectangular it becomes (r cos(theta) + r sin(theta) j)
So if we have 24.237-37.972 polar
then its rectangular will be
( 24.237cos(-37.972) + 24.237 sin(-37.972) j)
Now you can use these formula to convert from polar to rectangular coordinates
x = r cos (theta)
y = r sin (theta)
so rectangular coordinates become (r cos(theta) + r sin(theta) j)
Now excel expects the angle to be in radian, so if your angle is in degree, you will have to use excel's RADIANS function to convert the degree angle into radian and then use the cos formula,
So the formula will be x = r * cos (RADIANS(theta))
y= r * sin(RADIANS(theta))
Let me know if there are any doubts
I am really sorry but I cannot get my head around this - plus I am an oldie (65 years) so its probably very simple.
Can you put the figures into the formula for me - for example =24.237*cos(RADIANS(37.972)) IS THAT CORRECT???
Thanks for being there - you are working late???
Real_num is the real coefficient of the complex number.
I_num is the imaginary coefficient of the complex number.
Suffix is the suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be "i".
So in our case suppose we have the x data in E4 and y data in G4, we will have to use
this will give the result as
to get it into that format, ROUND is needed since complex function by default converts data into 15 decimal places and that does not look good.
If you do not want even those 2 intermediary columns for x and y , you can use
but that becomes a bit complicated.
Also, once you convert into complex , you will need to use complex number functions to get real (x) and imaginary (y) part from that value or to perform any further calculation
Hope that helps.
OK you have been Excellent - I will not ask further on the second Q as you have given me a good pointer to get it working.
If I need you again after I have accepted how do I get back to you - Dave