Hi,
I am having problems creating a formula for the below any ideas? Imagine column a-c and rows 1-6
<tbody>
</tbody><colgroup><col><col span="2"></colgroup>
I am having problems creating a formula for the below any ideas? Imagine column a-c and rows 1-6
Low | High | Rebate |
0 | 3000000 | 1 |
3000001 | 4000000 | 1.25 |
4000001 | 5000000 | 1.5 |
5000001 | 6000000 | 1.75 |
6000000 | 6000001 | 2 |
Spend= 2500000 | Rebate=?? |
<tbody>
</tbody><colgroup><col><col span="2"></colgroup>