Returns TRUE if the first value is between the lower and upper limits.
SppIsBetween([Test value],[Lower value],[Upper value],[Inclusive])
Where:
Test value is the value to test.
Lower value is the lower limit.
Upper value is the upper limit.
Inclusive is FALSE to exclude lower and upper limits, TRUE to include the limits.
| Rule | Result | Meaning |
|---|---|---|
| SppIsBetween(45,35,64,TRUE) | TRUE | Will return TRUE as 45 is between the 35 and 64 values. |