# Carry Data over

1. ## 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.

2. ## 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

3. ## 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.

4. ## Re: Carry Data over

Thats ok.
Result in M4

There are currently 1 users browsing this thread. (0 members and 1 guests)