Hi Friend,

Im just new here. Hope you can help me in computing rebate format.

Example. Sales x % (with Range)

Range:

10,000 to 14,999 = 1%
15,000 to 19,999 = 2%
20,000 onwards = 3%

Please help me to create formula.

Thanks,