Qualify rules with ranges and lists

You can use values for any data type except Boolean in conditions, condition cells, and filters.

These values can be imprecise. They can be in the form of a range expressed in the format: x..y, where x and y are the starting and ending values for the range.

The values can also be very specific. They can be in the form of a list expressed in the format {x,z,y}, where the values are in any order but must adhere to the data type or the defined labels when the data type is bound to an enumerated list with labels.

Contents

• Ranges and lists in conditions and filters
• Ranges and value sets in condition cells