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 formula do i need in cell A2 to do this?
I have looked for 2 hours and can't find how to do it.
2 Replies
Similar to HansVogelaar but as a 365 user I tend to use Lambda functions wherever I can. In particular, I would apply the Eval name to
Evalλ = LAMBDA(text, EVALUATE(text))so that the worksheet formula is
= Evalλ(A1)or, using a further defined name
= Evalλ(formulaText)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.
