I and other experts will get on to solve your problem. Could you help us by providing the following information :

Could you elaborate your problem as to what do you want and what is not happening ?

Are you drawing a chart where you want rectangular instead of polar or do you just want to simply convert from polar to rectangular ?

Also, you could upload the excel file here and when the upload completes, you will get a download link, post that in your next post so that I can correct the problem with that.

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))

Sorry but my internet is playing up. have tried your answer and whilst the results are close to the correct answer they are not the same. Could you please enter my figures into excel at your ens and see if you get the correct answer. If so I must be entering the formulas incorrectly. Thanks Dave

Hi there, When I do this in my excel for , 24.237-37.972 polar and the answer is 19.11-14.91j rectangular say I have columns as

A B C = A1 * cos(RADIANS(B1) D = A1 * sin(RADIANS(B1) 24.237 -37.972 19.10631 -14.9125

I hope you are getting same answer.

Now you say answer is 19.11-14.91j rectangular right which is actually the value we have got from excek rounded up to 2 decimal places, If we want rounded up to 2 decimal places, we can use the ROUND funstion in excel SO For rounding up to 2 decimal places, the formula will be

x =ROUND(A1*COS(RADIANS(B1)),2) y = ROUND(A1*SIN(RADIANS(B1)),2)

Well it looks like I have typed it in correct - but my Excel gives me 19.3352 - this is why I questioned it - so is there a difference in versions of excel? when we get this correct - can I ask one other Q or do I have to start a new thread? regards Dave

Well, that is very strange to me that it is giving slightly incorrect results to you. I have tried in Excel 97- 2003 format and Excel 2007. Which version do you have ?

Make sure that there is no typographical error and you are entering the exact formula in excel that is =24.237*COS(RADIANS(37.972))

Or are you using the formula with some other values which are getting calculated by some other formula and using them in this formula instead of (24.237, 37.972). The case may be that you are thinking that they are (24.237, 37.972) but they are actually slightly different and hence the result

If you have a excel sheet and nothing private and you want me to look into it you can upload it, You could upload the excel file here and when the upload completes, you will get a download link, post that in your next post so that I can correct the problem with that.

You can ask another question if it is related to this one here itself or you can ask it in a separate thread as it would get more attention.

You are correct it was a mistake in my original data - so I am happy. the other question is this - I have 2 cells resulting in 24.2373 in one sell and 37.972 in the other - is there any way I can automatically combine these into one cell resulting in 24.2373+37.972j so that further calculations can be made on the one cell.Regards Dave

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.

abhi_iitian and 4 other Programming Specialists are ready to help you