solve equation written in another cell?

[mabubakerali]

I have some math problem written in others cell and i want its answer to appear in other cell

Example:
in cell A2 i have 2*3*(5+4) and i want its answer to be appeared in B2

 

[Special-K99]

excel - How to turn a string formula into a "real" formula - Stack Overflow
or
https://superuser.com/questions/253...at-evaluates-a-string-as-if-it-were-a-formula

 

[hiker95]

mabubakerali,

How about something like this?

Excel 2007
	A	B
1
2	2*3*(5+4)	54
Sheet1

Cell Formulas
Range	Formula
B2	=Eval(A2)

The Function in cell B2, copied down:
=Eval(A2)



How to install the User Defined Function:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given below)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The function is installed and ready to use as shown in the example above.

Function Eval(Ref As String)
' hiker95, 04/03/3017, ME998908
' https://www.mrexcel.com/forum/excel-questions/998908-solve-equation-written-another-cell.html
' excel - How to turn a string formula into a "real" formula - Stack Overflow
' If A2 contains "2*3*(5+4)" without the " characters.
' In B2 type in "=Eval(A2)" withoue the " characters.
' B2 would display "54" without the " characters.
Application.Volatile
Eval = Evaluate(Ref)
End Function

Then follow in instructions in the Function.