<< Click to Display Table of Contents >> Navigation:  User guide > Logic > Simple test on spreadfield

test of spreadfield - true if the spreadfield contains:

spreadfield / iconstant                        the value of the constant

spreadfield / iconstant1..iconstant2        any value in the range given (inclusive)

spreadfield / B                                no fields contain a value

spreadfield / S                                  one (and only one) field contains a value

spreadfield / M                                  more than one field contains a value

 

The individual fields in the spreadfield are treated as values. The maximum value allowed is determined by the width of each field. Any field that does not contain a value of one or more is ignored. Duplicate values are also ignored.

Examples of simple tests on spreadfields:

$1210-1211*5/12,

$101-103*10/1..20,

$201-203*20/b,