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:

[TABLE="align: left"]
<tbody>[TR]
[TD]£5000 - £10,000
[/TD]
[TD]times by 15%
[/TD]
[/TR]
[TR]
[TD]£10,001 - £20,000
[/TD]
[TD]times by 25%
[/TD]
[/TR]
[TR]
[TD]£20,001 - £30,000
[/TD]
[TD]times by 30%
[/TD]
[/TR]
[TR]
[TD]£30,001 +
[/TD]
[TD]times by 35%
[/TD]
[/TR]
</tbody>[/TABLE]






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!