Evaluate math formula from Equation editor into cell

[Tricepsratops]

Hello MrExcel community, this is my first post, so if there is anything about this post that isn't posted correctly feel free to tell.

OK so going into the main thing, In my Excel sheets I use plenty of long and complex mathematical equations, that when trying to replicate form paper into Excel, it makes a total mess of parentheses "(" ")" making it difficult to track where the missing parentheses are, or where I am in the equation. To sum it up, it is a waste of time.

What am I exactly looking for? I want to create long equations using the Excel equation creator editor Picture 1, to the outcome into a cell that I can later evaluate, Picture 2.

Picture 1: Excel equation editor.



Picture 2: Example of the desired outcome.​

Note: Picture 2 example has been written "by hand".

Things to consider: Copy-Pasting an equation into a cell does not actally work, makes a mess of parentheses, sqrts, sins... lets say it does not export correctly; for example, whatever it is in a sqrt needs to be in parentheses or will not export the needed parentheses to evaluate, even if it is only a single number what you want to sqrt.

I know this may be difficult to understand, so please, if you don't understand something just say so and I will try to explain it more calmly. Thank you all.

 

[6StringJazzer]

The equation editor is only to write text that uses mathematical notation. It has no relationship to creating Excel formulas that will give a result. It is only for display purposes in a textbox.

If you want to replicate the math from the Equation editor in a cell you have to actually do the math and develop the formula yourself, exactly as you did in Picture 2.

 

[Tricepsratops]

Thank you although it could be a nice feature for upcoming versions.