Hi There, i am trying to work out how to produce a formula that will calculate the fee due based on the total fund value which can be populated in. The currency field which will be populated is called 'Total transfer value for Tiered Fee'. 

when this field is populated with a value i need the formula to calculate the following:

3% of the first £500k
2% of the next £250k
1% thereafter. If the total after calculating this, exceeds £30,000, i need this to deliver £30k as the maximum.

Any help would be greatly appreciated!

thanks,

Khan



 

Hi There, i am trying to work out how to produce a formula that will calculate the fee due based on the total fund value which can be populated in. The currency field which will be populated is called 'Total transfer value for Tiered Fee'. 

when this field is populated with a value i need the formula to calculate the following:

3% of the first £500k
2% of the next £250k
1% thereafter. If the total after calculating this, exceeds £30,000, i need this to deliver £30k as the maximum.

Any help would be greatly appreciated!

thanks,

Khan