Hi All,
Yesterday I posted a thread for a formula to produce the results of this table, and AliGW helped me out with the formula below:
£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%
=AF3*LOOKUP(AF3,{0,5000,10001,20001,30001},{0,0.15,0.25,0.3,0.35})[TR=px"class: cms_table"
[TABLE="class: cms_table, align: left"]
<tbody></tbody>[/TABLE]
However, I just found out that I actually need to formula to calculate the table like this:
For the first £0 - £5,000 - times by 0%
For the next £5000 - £10,000 - times that by 15%
For the next £10,001 - £20,000 - times that by 25%
For the next £20,001 - £30,000 - times that by 30%
for everything above £30,001 + - times that by 35%
So for example, if the value is £45,500
0 (£5,000 x 0%)
+ 750 (£5000 x 15%)
+ 2500 (£10000 x 25%)
+ 3000 (£10000 x 30%)
+ 4650 (£15500 x 35%)
----------------------------
= 10,900
or if the value is £27,250
0 (£5,000 x 0%)
+ 750 (£5000 x 15%)
+ 2500 (£10000 x 25%)
+ 2175 (£7250 x 30%)
----------------------------
= 5425
Cheers
Yesterday I posted a thread for a formula to produce the results of this table, and AliGW helped me out with the formula below:
£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%
=AF3*LOOKUP(AF3,{0,5000,10001,20001,30001},{0,0.15,0.25,0.3,0.35})[TR=px"class: cms_table"
[TABLE="class: cms_table, align: left"]
<tbody></tbody>[/TABLE]
However, I just found out that I actually need to formula to calculate the table like this:
For the first £0 - £5,000 - times by 0%
For the next £5000 - £10,000 - times that by 15%
For the next £10,001 - £20,000 - times that by 25%
For the next £20,001 - £30,000 - times that by 30%
for everything above £30,001 + - times that by 35%
So for example, if the value is £45,500
0 (£5,000 x 0%)
+ 750 (£5000 x 15%)
+ 2500 (£10000 x 25%)
+ 3000 (£10000 x 30%)
+ 4650 (£15500 x 35%)
----------------------------
= 10,900
or if the value is £27,250
0 (£5,000 x 0%)
+ 750 (£5000 x 15%)
+ 2500 (£10000 x 25%)
+ 2175 (£7250 x 30%)
----------------------------
= 5425
Cheers