Hello
Can anyone help me write a single formula that will solve for the total fee to be deducted given this fee card:
First 100 - 1.25%
Next 200 - 1.00%
Next 400 - 0.75%
Balance above 700 - 0.50%
I have only been able to do it so far using a range of cells.
Many thanks
Tom
Can anyone help me write a single formula that will solve for the total fee to be deducted given this fee card:
First 100 - 1.25%
Next 200 - 1.00%
Next 400 - 0.75%
Balance above 700 - 0.50%
I have only been able to do it so far using a range of cells.
Many thanks
Tom