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. |