
1 Attachment(s)
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.

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

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.

1 Attachment(s)
Re: Carry Data over