Hi.

I'm trying to calculate i discount that is applied in steps (in Norwegian
this is called "staricase" rebate). If total sales are between 0 and 4
million no discount is applied, between 4 and 8 million 4% is applied on
sales above 4 million, if total sales are between 8 and 12 million 4% is
applied on the sales between 4 and 8 million and 6 % on sales above 8
million, etc.

The structure can be illustrated like this
From To Discount
3 999 999 0,00
4 000 00 0 7 999 999 0,04
8 000 000 11 999 999 0,06
12 000 000 15 999 999 0,08
16 000 000 0,10

I could make a nested IF-statement looking someting like
'=-1*IF(N$8<k!$C$4;N$8*k!$D$4;IF(N$8<k!$C$5;k!$C$4*k! $D$4+(N$8-(k!$C$4))*k!$
D$5;IF(N$8<k!$C$6;k!$C$4*k!$D$4+(k!$C$5-k!$C$4)*k!$D$5+(N$8-(k!$C$5))*k!$D$6
;k!$C$4*k!$D$4+(k!$C$5-k!$C$4)*k!$D$5+(k!$C$6-k!$C$5)*k!$D$6+(N$8-k!$C$6)*k!
$D$7)))', but there must be a more simple way of calculating this kind of
discount.



Rgds

Thomas, Norway