Help with an IF formula

[visionate]

I'm not the best with excel and I am trying to put together the the following formula, can someone let me know where I have gone wrong?

=IF(AF43<=AE10,AF43*0.15,IF(AND(AF43>AE10,AF43<=AE11),AF43*0.25,IF(AF43>AE11,AF43<=AE12),AF43*0.30,IF(AF43>AE12),AF43*0.35,"")))

What I need to achieve:

If A1 is between this value and this value, then times it by this percentage. Here is the table it applies to:

£5000 - £10,000	times by 15%
£10,001 - £20,000	times by 25%
£20,001 - £30,000	times by 30%
£30,001 +	times by 35%

<tbody>
</tbody>

I have put these values in field in excel but it would be even better if they could be in the formula.

Look forward to your help.

 

[AliGW]

Try this instead:

=AF3*LOOKUP(AF3,{0,5000,10001,20001,30001},{0,0.15,0.25,0.3,0.35})

 

[AlanY]

try, I've assumed 0 for less than 5000, adjust accordingly

=LOOKUP(AF43,{0,5000,10001,20001,30001},{0,0.15,0.25,0.3,0.35})*AF43

 

[visionate]

Thanks works perfect

 

[AliGW]

You're welcome!