SOLVED

Using IF with AND, OR

New Contributor

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%

 

3 Replies
best response confirmed by FredExcel (New Contributor)
Solution

@FredExcel That would be in E12:

=LOOKUP(E10,A1:A9,C1:C9)

 

Thanks, much appreciated.

@FredExcel You're welcome!