Formulas

Arithmetic

GroupEnable Formula

Basic Formula

Parentheses (Nested Groups)

Nested Groups act like mathematical parentheses. In other words, deeper Groups are computed before their parent(s). They have an operator unless they are the first formula item.

Spring Work Math Formula

Rounding

Rounding Half Up

Presets

GroupFormula Presets

To remove a preset, re-click the active preset button.

Formula Presets

Choice Groups

Formulas use the selected Item Value.

Checkboxes

Internally, a Checkbox value is 1 or 0. This example multiplies that value by $5.00 (a "Auxiliary" Item) using a formula. Effectively, this is a no-code conditional form.


Next Shortcuts  ️⇾