Hi
I’m trying to work out an appropriate formula to automatically calculate commission. Our commission structure is below;
<tbody>
Commission band £12,500
Percentage
0 – 50%
2.5
50 – 75%
5
75 – 100%
10
100 – 150%
15
150 – 200%
20
200% +
30
</tbody>
Commission is calculated...