4 ms·
Use the LET formula. It gives you lexically scoped variables inside a formula. =LET(foo, ComplicatedExpression(), bar, AnotherComplicatedExpressio
by _dain_ 4y ago
Use the LET formula. It gives you lexically scoped variables inside a formula.
=LET(foo, ComplicatedExpression(),
bar, AnotherComplicatedExpression(),
baz, AnExpressionInvolvingPreviousVariables(foo, bar),
ExpressionThatIsTheReturnValue())
Excel now also has (will have?) a LAMBDA formula for defining your own functions.