Forum Discussion
calculating a sliding scale percentage based on value of a sum
for one of my customers I need to return a rebate on sales. however we have two sales funnels to consider and the rebate amount is a sliding scale based on total sales. I need to sum 2 cells and dep...
| Cell1 | Cell2 | Sum | Rebate | |||
| C11 | D11 | E11 | F11 | |||
| 400000 | + | 500000 | = | 900000 | ==> | 45000 |
copy in cell F11:
=IF(E11>2000000;(E11*7%);IF(E11>1000000;(E11*6%);(IF(E11>500000;(E11*5%);0))))
[This formula works only if your language settings are US or UK if not, you need to replace the IF function with you local formula function eg. for the Netherlands I need to replace IF with ALS than the formula will look like =ALS(E11>2000000;(E11*7%);ALS(E11>1000000;(E11*6%);(ALS(E11>500000;(E11*5%);0)))) ]