New in Formulas 2.0
The lets()
function will allow you to assign values to multiple variables, and then use those variables in the expression.
lets(variable, value, variable, value, ..., expression) variable.lets(value, variable, value, ..., expression)
Note that the resulting variables can only be used between the brackets of the original lets()
function.