Apr 19 2021 06:14 AM
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% |
Apr 19 2021 06:57 AM
SolutionApr 19 2021 06:57 AM
Solution