Forum Discussion
Excel formula cells without =, but want to make a formula of it
Hello, Hopefully somebody can help me. I want to make a formula that solves a formula in a cell without a = sign. Example: Cell A1 = 2+4+6+12 Cell A2 = Answer of cell A1 What formul...
Select A2
On the Formulas tab of the ribbon, click Define Name.
In the Name box, enter Eval
In the Refers to box, enter =EVALUATE(!A1)
Click OK.
In A2, enter the formula =Eval
You can now enter an expression such as 2*(23-3) in any cell, and enter the formula =Eval in the cell below it.