Rules & Calculation Formulas · Calculation functionsOperational Master Data RepositoriesRules & Calculation Formulas
Threshold band
FN-11- Category
- Comparison
Places a value in one of three bands by two thresholds: up to the first (inclusive), below the second, or from the second on.
IF(Value ≤ Up to, Outcome up to the first threshold, IF(Value < Below, Outcome between, Outcome from the second threshold))
Example: IF(3,200 ≤ 500, …, IF(3,200 < 5,000, "Finance approval", …))