# Carry Data over

• 08-12-2019, 10:34 AM
CharlesBrandt
Carry Data over
I need help in carrying data over.
if the total of a sum is 124 units, how do I get it to calculate the amount owed if every 25th units starts with a new price.
example is that the first 25 units cost 10. the second 25 units cost 12, the 3rd 25 units is 14 and so on.

i added an excel sheet that might explane more.

hope you can help.
• 08-12-2019, 10:40 AM
Special-K
Re: Carry Data over
This is what's called a tiered commission, where salesmen at different levels get different commission rates

=SUMPRODUCT(--(E4>={0,25,50,75,100,125}),E4-{0,25,50,75,100,125},{10,2,2,2,2,2})

The inline arrays as you can see indicate the different usage levels, the last inline array in the formula indicates the initial value (10) and the increases (+2, +2,+2 etc) for each usage
• 08-12-2019, 11:45 AM
CharlesBrandt
Re: Carry Data over
I cant seem to get it to work. Can you maybe send the excel sheet back please.
Sorry im a noob at this.
• 08-12-2019, 11:51 AM
Special-K
Re: Carry Data over
Thats ok.
Result in M4