Hi,
I am attempting to use a Sumproduct Froumla to work out commission but it isn't quite working.
The below is what I am attempting.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Profit for 1 person is 1000. 0-15 0% commission. 16-30 10% - so the commision should be 1600 for 16 people hired but my formula is pulling through 3194.8. Then a further 5% for any over 30. and so on.
Hope this makes sense.
Let me know if it doesn't.
Thanks,
Dell
I am attempting to use a Sumproduct Froumla to work out commission but it isn't quite working.
The below is what I am attempting.
Profit | 1000 | ||
Starters | 1 | ||
Actual starters | 16 | ||
16000 | |||
Commision: | 3194.8 | =SUMPRODUCT(--(16000>0;16;31;41),--(16000-0;16;31;41),0;0.1;0.05;0.05) | |
Low Threshold | High Threshold | Rate | Diff.Rate |
0 | 15 | 0% | 0% |
16 | 30 | 10% | 10% |
31 | 40 | 15% | 5% |
41 | 20% | 5% |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Profit for 1 person is 1000. 0-15 0% commission. 16-30 10% - so the commision should be 1600 for 16 people hired but my formula is pulling through 3194.8. Then a further 5% for any over 30. and so on.
Hope this makes sense.
Let me know if it doesn't.
Thanks,
Dell