Help IfElse Condition with Slab Pricing

This should work

ifelse (Usage <= 10000, Usage * .08,
Usage < 40000, 800 + (USage - 10000) * .04,
800 + 12000 + (Usage - 4000) * .01)

1 Like