between
Determines if a value falls in a given range.
Syntax
expression between value1 and value2Example
[Revenue] between 200 and 300Result
Returns the number of results with revenues between 200 and 300.
Result data
| Revenue | Between |
|---|---|
| $332.06 | false |
| $230.55 | true |
| $107.94 | false |