Does Excel have a function to convert rectangular to polar and back?

Yes.

Just activate the built-in Analysis Toolpak Add-in.

http://www.engineerexcel.com/complex-numbers-in-excel/

How you activate it varies from version to version. In Excel 2010 (what I have) you access it from the File-Options menu.

 

Hi,

Can Excel do symbolic algebra/calculus?

 

Hi,

Can Excel do symbolic algebra/calculus?

No, you'd want to look at Mathematica for that.

 

Thee End...

Oh dang - Can't upload my fancy new calculator. What the heck? No excel extensions.

Well it's the end for me anyways

 

Thee End...

Oh dang - Can't upload my fancy new calculator. What the heck? No excel extensions.

Well it's the end for me anyways

Were you trying to attach an Excel file here? That should be OK. Use the "Upload a File" button you see below.

 

Sorry wayneh was off working on a spreadsheet to analyse transmission lines.

The problem might be because it's an xlsx file, I've excel 2016 free from the uni.. I remember there used to be similar problems with docx files. I'll convert it to the xls version tomorrow and see if it uploads.

 

No, you'd want to look at Mathematica for that.

Hello there,

Well i know other programs can do it, just wanted to know if Excel could do it. By your response i take it that it can not do it. I thought that was the case as i thought Excel was basically a number machine at it's heart. Now i know for sure, thanks. That tells me it's probably not for me because i need symbolic operations most of the time (although not all the time).

 

Sorry wayneh was off working on a spreadsheet to analyse transmission lines.

The problem might be because it's an xlsx file, I've excel 2016 free from the uni.. I remember there used to be similar problems with docx files. I'll convert it to the xls version tomorrow and see if it uploads.

Huh, I’m surprised you had a problem. Try zipping the file first?

 

Yeh that worked I think.
Surprisingly it wouldn't even let me upload the basic xls file???

 

Hello,

I have enabled xls and xlsx for attachments

Bertus

 

Hello,

I have enabled xls and xlsx for attachments

Bertus

That's a good idea ... but it would also be a good idea to filter those sheets that have macros programmed in them. Although I doubt this site has that capability.

 

Hello,

Usualy the macro files end on xlm or xlsm.
It is to the user to set safety in excel to block macros.
I often see the message in excel if I want to activate the macros.

Bertus