Use the BETWEEN function in the Properties editor and Query
editor to filter or add a threshold indicator when a value falls within
a range.
- See
if value is within a range
- Compares all values between two numbers. When you select the function,
the Range Parameters window opens. Enter the first and last numbers
in the value range. The relational operators available are == Equal
and != Not Equal.
- Exclude range start/end
from evaluation, when left unchecked, includes the values entered
in the range. The expression ends with 0 if this is left unchecked;
1 if it is checked (see example).
- Example
- The comparison is true if Copy Read Hits is between 50% and 60%.
BETWEEN (Copy Read Hits %) == 50,60,1
- Hexadecimal numbers
- When entering a hexadecimal value in a cell, prefix the number
with zero and the letter “x”, as in 0x123ab for hex value 123ab.