Hello,
I was hoping for some assistance, I am an excel novice and I was looking to produce a formula that would enable me to show the following
If E11>=A1,E11<=B1 then E12 =2.00% or if E11>=A2,E11<=B2 then E12 =1.75%, or if E11>=A3,E11<=B3 then E12 =1.50% etc the formula would the go on with these conditions until £100,000,000.
| A | B | C | D | E |
1 | £0 | £25,000 | 2.00% | 2.00% | |
2 | £25,001 | £50,000 | 1.75% | 1.75% | |
3 | £50,001 | £100,000 | 1.50% | 1.50% | |
4 | £100,001 | £250,000 | 1.25% | 1.25% | |
5 | £250,001 | £500,000 | 1.00% | 1.00% | |
6 | £500,001 | £1,000,000 | 0.70% | 0.70% | |
7 | £1,000,001 | £3,000,000 | 0.65% | 0.65% | |
9 | £3,000,001 | £5,000,000 | 0.60% | 0.60% | |
10 | £5,000,001 | £100,000,000 | 0.55% | 0.55% | |
11 | | | | | £15,000 |
12 | | | | | 2.00% |
