Is there a way to convert Excel formulas to "typeset" style?

Question

I'm thinking something like the Matlab "pretty" function.  It would be nice to be able to take something that looks like =(-B1+sqrt(B1^2-4*A1*C1))/(2*A1) and output something like

-b + √(b² - 4∙a∙c)
------------------------
2∙a

Anybody know of anything like that?

? · Accepted Answer

There's Wolfram Alpha, a website that also does certain analyses on queries you give:
http://www.wolframalpha.com/

It might not catch all of the Excel-style functions, but you should be able to get most things done.

Within Excel, you would have to use parsing macros, or perhaps the Equation Editor that may have been installed alongside your Office software.

[add] Offhand, I don't know of any such macros, but it's definitely something that macros can do.

Some more on Equation Editor: http://office.microsoft.com/en-us/excel-help/insert-an-equation-with-equation-editor-HP001118120.aspx

Altogether, this would work fine for equations that you're sending to another program. Excel still needs the formulas in its own style for calculation.

sid · Answer

I don't believe this is possible. Even if you do enable macro its not going to work if you pull it up on another computer.

Is there a way to convert Excel formulas to "typeset" style?

Related Questions

Trending Questions