Constraints are limitations or conditions placed on the variables in your spreadsheet. They are expressed as algebraic statements appended to formulas. You can attach a constraint expression to any formula, by typing a semicolon (;) and the constraint conditions after the formula.
Constraint expressions establish conditions under which a
formula operates or boundaries for valid results of the
formula. Constraint expressions may be simple
equality/inequality relationships, or they can be
arbitrary formulas. Any valid NExS expression which
returns a numeric value is also a valid constraint
expression. However, unlike the expression that defines
a cell value, a constraint expression can reference the
cell in which it resides, using the symbol #
.
For example, the formula
=A1 + A2 ; #>2 && #<=B5 || #==C7
Constraint expressions are used in several other contexts within NExS, including the Find and Extract Tools, and the conditional statistical functions.
The benefit of constraint expressions is maximized when
combine with current cell reference support (#
) as indicated
in the above example.