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:
<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.
=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.