Syntax
With(Record, Formula)Examples
=With({ subtotal: Sum(colCart, Qty * Price) }, subtotal + subtotal * 0.2)The total including 20% tax
Maker notes
- The names exist only inside the formula, which keeps long expressions readable.
With
Gives names to values for use inside one formula, without creating variables.