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...
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)