Lookup Table Value Reference

This table describes the rules for specifying values in lookup tables.

Item Guideline Example
Value separator (delimiter) Commas: n, n+1, n+5 5,6,7 5.5,6.25
Continuous range of values that includes the specified values Brackets: [n, n+5] [3,10] = value between 3 and 10, including 3 and 10
Continuous range of values that does not include the specified values Parentheses: (n, n+5) (3,10) = value between 3 and 10, not including 3 and 10
Less than or equal to (open-ended range) Value preceded by comma, enclosed in brackets: [,n] [,5] = value less than or equal to 5
Greater than or equal to (open-ended range) Value followed by comma, enclosed in brackets: [n,] [5,] = value greater than or equal to 5
Greater than Value preceded by comma, enclosed in parentheses: (,n) (,5) = value greater than 5
Less than Value followed by comma, enclosed in parentheses: (n,) (5,) = value less than 5
Maximum characters per cell 256  
Unit of measurement syntax Metric or architectural 15'1/4" = imperial

15.25 = metric

Invalid formats If you enter a value in an invalid format, the value will be reset to the last value when you move to another cell in the table.