The lower bound value — a number, or a formula whose result is compared per cell.
A formula is authored as a =-prefixed string or an ICalculation.IFormula; a resolved
condition holds it as an IFormula.
null while not yet given. The comparison matches nothing, and excludes nothing, until both
bounds are.
The upper bound value — a number, or a formula whose result is compared per cell.
A formula is authored as a =-prefixed string or an ICalculation.IFormula; a resolved
condition holds it as an IFormula.
null while not yet given. The comparison matches nothing, and excludes nothing, until both
bounds are.
Options for specifying a value within a range.
Remarks
Purely convenience. This is logically equivalent to
operator: 'and', [{ operator: 'greaterThan', param: value }]but it's common enough that it's worth having a dedicated operator+option for it.