pauljleonard
New Member
- Joined
- Oct 31, 2018
- Messages
- 7
Hope you can help!!
I have a progressive pricing formula I need help with, been tearing my hair out
Each band gets individual earnings in steps apart from <10 that gets nothing.
In the below example customer sells 35 baskets, so will reach the 4th band.
Band 1 - Zero
Band 2 - 10 * £1.15 = £11.50
Band 3 - 10 * £2.30 = £23.00
Band 4 - 10 * £3.15 = £31.50
As he only has 5 baskets in Band 4, he only gets 5 * £3.15 = £15.75
Total earnings therefore is £81.75
It may be better to have a formula individually in each row, and sum the row for total earnings?
<tbody>
</tbody>
I have a progressive pricing formula I need help with, been tearing my hair out
Each band gets individual earnings in steps apart from <10 that gets nothing.
In the below example customer sells 35 baskets, so will reach the 4th band.
Band 1 - Zero
Band 2 - 10 * £1.15 = £11.50
Band 3 - 10 * £2.30 = £23.00
Band 4 - 10 * £3.15 = £31.50
As he only has 5 baskets in Band 4, he only gets 5 * £3.15 = £15.75
Total earnings therefore is £81.75
It may be better to have a formula individually in each row, and sum the row for total earnings?
| band | baskets | rate |
| 1 | 0 | $0.00 |
| 2 | 10 | $1.15 |
| 3 | 20 | $2.30 |
| 4 | 30 | $3.15 |
| 5 | 40 | $4.45 |
<tbody>
</tbody>
